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.
FTPPX Stage converting Dates to number on transfer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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