Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 03 May 2013 @ 15:22:58 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Error while FTP data from MF file to CSV file
From:   Geoffrey Rommel

If I understood your statement of the problem, the data is going like this: Export Teradata via mainframe FastExport to mainframe flat file.

Send mainframe flat file via FTP from z/OS to (Windows? Linux?). ...somehow convert to a CSV...

Read the file with Excel. A certain field is rounded.

This raises a number of questions. (1) If the data is eventually going to Windows (PC or server), why use z/OS? Can you run FastExport or TPT on Windows directly? (2) Is the mainframe flat file entirely in character format, or are some fields packed-decimal? (3) Is the FTP binary mode or ASCII mode? If the flat file contains packed fields, it must be transmitted in binary and translated on the Windows side; if it doesn't, ASCII transfer should work. (4) You said "Its a problem with excel". Does this mean that you've verified the CSV file contains all the digits and you're just asking an Excel question?

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020