Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Error while FTP data from MF file to CSV file
From:   sughesh.iyyani

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.


Sughesh I S.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023