Page 1 of 1

ftp'd fixed-width file has no data

Posted: Thu Apr 13, 2006 9:05 am
by MarkTralls
Hi

I am trying to ftp a fixed-width sequential file to a Windows box, using the ftp plug-in.

The correct number of rows are being output, but no data, only a return on each row.

If I change Fixed-width property of ftp plugin back to No, and use a delimeter, no problem, the data gets exported.

If I change Fixed-width property back to Yes, the same thing happens, just returns. There does not appear to be any other settings I can change.

When you view the data coming out of the link from the sequential file, it's fine.

Please does anyone have any ideas?

Thanks

Mark

Posted: Thu Apr 13, 2006 9:25 am
by ArndW
What is the data defined as in the column page (type, length) and what did you set the fixed width to?

Posted: Tue Apr 18, 2006 2:03 am
by MarkTralls
ArndW wrote:What is the data defined as in the column page (type, length) and what did you set the fixed width to? ...


Hi Thanks for the reply.

All columns are data type char, with their relevant lengths set. There are no fixed width settings (that I can see) .... I assummed it just used the column length (?).

Posted: Tue Apr 18, 2006 2:15 am
by ArndW
I'm not at a DS client to test this right now, but have you also specified the display width as well - as needs to be done with sequential files with fixed width?

Posted: Tue Apr 18, 2006 2:33 am
by MarkTralls
ArndW wrote:I'm not at a DS client to test this right now, but have you also specified the display width as well - as needs to be done with sequential files with fixed width?


Thanks! That did the trick!

That's one to remember!

Thanks again

Mark