Fixed width file in DS parallel job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sweety123
Participant
Posts: 18
Joined: Thu Dec 10, 2009 5:28 am

Fixed width file in DS parallel job

Post by sweety123 »

How do we specify an input file as fixed width in DS parallel job?
Is setting Field Deleimiter=None enough or is there any other way?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The easiest way is to import the table definition of the sequential file (specifying it as fixed-width, of course, and specifying the field widths) then, in the Sequential File stage, click Load while on the Format tab.

That way the metadata remain untouched by human hands and should be reasonably error free.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply