Generating Flat File of Fixed Width
Posted: 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
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