Page 1 of 1

Fixed Width File

Posted: Wed Jul 21, 2010 10:18 pm
by DSFreddie
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.

Posted: Thu Jul 22, 2010 12:54 am
by ray.wurlod
The Format properties of the Sequential File stage is where you specify a fixed width file format.

Posted: Thu Jul 22, 2010 12:55 am
by ray.wurlod
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.