Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019