ftp'd fixed-width file has no data

MarkTralls · Post by **MarkTralls** » Thu Apr 13, 2006 9:05 am

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

ArndW · Post by **ArndW** » Thu Apr 13, 2006 9:25 am

What is the data defined as in the column page (type, length) and what did you set the fixed width to?

MarkTralls · Post by **MarkTralls** » Tue Apr 18, 2006 2:03 am

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 (?).

ArndW · Post by **ArndW** » Tue Apr 18, 2006 2:15 am

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?

MarkTralls · Post by **MarkTralls** » Tue Apr 18, 2006 2:33 am

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