Archives of the TeradataForum

Message Posted: Tue, 30 Apr 2013 @ 13:44:48 GMT

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

Hi Folks,

We are facing an issue while doing FTP from Mainframe file to CSV file in server.

We have one column as Decimal(19,0), we casted the same to char(20) while creating MF file.

In MF file value of particular field is 120306140237191109., but in CSV file its getting rounded to 120306000000000000.

As we are doing this for automation process, we can't manually insert values and we can't format the column in CSV file as TEXT.

Process is deleting old file and creating new one with same name.

Could anybody give some inputs, so that this rounding can be avoided (without manual intervention).

Appreciate your time.

Thanks,

Sughesh I S.

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