Generating Flat File of Fixed Width

rkumar28 · Post by **rkumar28** » Wed Jul 14, 2004 10:45 am

Hi,

I am trying to generate a fixed width flat file from pipe delimited flat file. Basically, I am extracting from pipe delimited flat file, perfoming transformations and loading into the fixed width flat file.
The fixed width file has 15 columns and the width of all the column adds up to 925. But when I load the data into this file I get row length of 8205 in fixed width file instead of 925.

Once this file is generated, I do the FTP to MVS enviroment from unix.

Will appreciate any help to fix this problem.

Thanks
Raj

ds_developer · Post by **ds_developer** » Wed Jul 14, 2004 1:45 pm

Have you verified that the Length and Display values of the 15 columns in the sequential file are the same? DataStage is going to use the Display values to write the record. Also, your numbers don't look right - 925 isn't evenly divisible by 15 even if you're including a line terminator.

John