Fixed Width File

DSFreddie · Post by **DSFreddie** » Wed Jul 21, 2010 10:18 pm

I have one requirement in my project where we need to extract the data from Db2 table & send it across to the downstream as a FIXED WIDTH file.

Can you pls help me to create this DataStage job & the functions I need to use to create a FIXED width file?

Any help would be appreciated.

Thanks in advance.
Freddie.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 22, 2010 12:54 am

The Format properties of the Sequential File stage is where you specify a fixed width file format.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 22, 2010 12:55 am

The Format properties of the Sequential File stage is where you specify a fixed width file format.
The easiest way to learn what to do is to import the "table definition" for a fixed-width file, and look at what gets stored. Clicking the "Sync parallel" button before you inspect the parallel properties is a wise move.