Page 1 of 1
FTPPX Stage converting Dates to number on transfer
Posted: Mon Jan 24, 2011 8:46 pm
by piyu
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.
Posted: Mon Jan 24, 2011 11:06 pm
by ray.wurlod
What do the numbers look like? Do you regards 20110125 as a number?
Posted: Tue Jan 25, 2011 1:26 am
by piyu
2010-12-31 was converted to 15760
This records :
"2010-12-319331A904A1A9MIS256560111402008-11-05....."
looked like this when transferred :
"157069331A904A1A9MIS25656011140149201492092830155561555923..."
Posted: Tue Jan 25, 2011 3:58 am
by ray.wurlod
That looks like a Julian date of some kind. Can you please provide more details about the source and how that was generated?
Posted: Tue Jan 25, 2011 4:45 am
by piyu
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.
Posted: Tue Feb 15, 2011 10:33 am
by sjhouse
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