Archives of the TeradataForum

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

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

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>>