DSXchange

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

I have had no problems using FTP with fixed width files. What seems to be the error?

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?

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.

Try creating a dummy file with 3 rows of data, row 1 with 500 "a"'s, row 2 with 500 "b"'s and row 3 with 500 "c"s and see what your output is. You problem is most certainly settings in the FTP stage, but I don't know what you have done. Is your data field CHAR(500) with display of 500 as well?

Make sure the FTP setting are fixed width and not space delimeted.