FTPPX Stage converting Dates to number on transfer

piyu · Post by **piyu** » Mon Jan 24, 2011 8:46 pm

Any idea why the FTP PX stage would convert dates to a number format on transfer? The file on the source side is generated in Datastage and a view on UNIX shows the date formats to be correct. Any help will be appreciated.

No special FTP parameters specified.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 24, 2011 11:06 pm

What do the numbers look like? Do you regards 20110125 as a number?

piyu · Post by **piyu** » Tue Jan 25, 2011 1:26 am

2010-12-31 was converted to 15760
This records :
"2010-12-319331A904A1A9MIS256560111402008-11-05....."

looked like this when transferred :

"157069331A904A1A9MIS25656011140149201492092830155561555923..."

ray.wurlod · Post by **ray.wurlod** » Tue Jan 25, 2011 3:58 am

That looks like a Julian date of some kind. Can you please provide more details about the source and how that was generated?

piyu · Post by **piyu** » Tue Jan 25, 2011 4:45 am

Its a simple tab delimited file read and write to FTP stage.

I did use a workaround of converting the date to VARCHAR 10 in target. But just wanted to know why its doing that because some other similar job which runs fine with date.

sjhouse · Post by **sjhouse** » Tue Feb 15, 2011 10:33 am

i have a similar problem with a migrate 7.5 job to 8.5;

the file is tab delimited but when its ftp'ed the header row has tab escape character while the data rows are tab delimited. so did you have something similar i have opened a case with IBM will update

before FTP
PMI_NO BIRTH_DATE REFERRAL_CODE

After FTP
PMI_NO009BIRTH_DATE009REFERRAL_CODE

i did not mean to hijack your thread but have seen similar behaviour with your file header row