problem in integer type sequential file stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sandeepkumar833
Participant
Posts: 1
Joined: Mon Oct 11, 2004 10:48 pm

problem in integer type sequential file stage

Post by Sandeepkumar833 »

Hi,

I am trying to read from a flat file without any field delimiter.I am trying to read an 2 digit integer field (00 to 99).I am unable to get this field in the sequential file stage.When i click on view data I get garbled data which is 5 or 6 digit long.How can i read 2 digit integer without using delimiter?
Thanks for your help.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Set the Display width in the columns grid to the actual width of the column. (You ought to have done this during the import of Sequential File metadata.)
Make sure, too, that the file format is marked as fixed-width rather than delimited.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Post by mandyli »

Yes

please check sequential file is fixed-width. we also faced same kind of problem then we changed our file format.

Please try.

Thanks
Man
Post Reply