Hi All,
I am trying to FTP fixed width file containing a single column.
But after the ftp I am not able to ftp the complete file only the first few columns data seems be be getting ftpied.
anyone has any idea like what could be reason for this?
Many Thanks,
Sandeep S Pendem
Not able to FTP fixed width file using FTP Plug in stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it contains a single column, why do you mention "the first few columns"? Do you mean "the first few rows"? That some rows are getting through suggests that the FTP mechanism is intact - you will need to do some detective work to determine why only a few rows. For example: Can you FTP the entire file outside of DataStage? Does your job run with row limits?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray/Arnd,
Thanks for your answers
The problem I am facing is The Incoming data has some blank values in it and the file is fixed width file of varchar(500).
The data from the source looks lik somewhat:
1#HDR 0000
2#RSAP0020032102CLAIM0000001 00000032
2#RSAP0020032102 00000032
The O/p I m getting after the FTP is
1#HDR 0000
2#RSAP0020032102CLAIM0000001
2#RSAP0020032102
I am not able to see the rest of the data.
Similary when I tried ftp using the server job with the same sequential file source data.
the o/p appears lik
1#HDR 0000
2#RSAP0020032102CLAIM000000100000032
2#RSAP002003210200000032
Here the spaces are missing and the next values appears to be at wrong position.
Please advise on whether I am missing something in this cases.
Thanks for your answers
The problem I am facing is The Incoming data has some blank values in it and the file is fixed width file of varchar(500).
The data from the source looks lik somewhat:
1#HDR 0000
2#RSAP0020032102CLAIM0000001 00000032
2#RSAP0020032102 00000032
The O/p I m getting after the FTP is
1#HDR 0000
2#RSAP0020032102CLAIM0000001
2#RSAP0020032102
I am not able to see the rest of the data.
Similary when I tried ftp using the server job with the same sequential file source data.
the o/p appears lik
1#HDR 0000
2#RSAP0020032102CLAIM000000100000032
2#RSAP002003210200000032
Here the spaces are missing and the next values appears to be at wrong position.
Please advise on whether I am missing something in this cases.