How to create FB file using FTP Stage

Suttond · Post by **Suttond** » Thu Mar 24, 2005 3:24 pm

We are using FTP stage to write a file to IBM enterprise server, with fixed width fields, nothing between the fields and cannot create anything but VB files. How do we cause the file to be FB?

roy · Post by **roy** » Mon Mar 28, 2005 7:19 am

Hi,
Can you give a bit more specific info?

(are you getting errors?, can you write a simple ascii file there?,...)

Suttond · Post by **Suttond** » Mon Mar 28, 2005 7:48 am

roy wrote:Hi,
Can you give a bit more specific info?

(are you getting errors?, can you write a simple ascii file there?,...)

There are no errors. The file allocates as a Variable Blocked (VB) file successfully, but all fields are fixed width and customer wants to read a Fixed Block (FB) file. Ascential says that we must preallocate the file, but we want to use Generation Data Groups and these files cannot be preallocated.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 28, 2005 1:14 pm

Can you do it with regular FTP (that is, not with DataStage)? If so, have DataStage generate a local file then run a script to perform the FTP operation.

As far as I know there is no property of the FTP stage that allows a file to be created as an FB file. Indeed, I don't think that the Sequential File stage can do it either.