Archives of the TeradataForum
Message Posted: Fri, 03 May 2013 @ 15:22:58 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|