DSXchange

Hi,

I have to read a fixed width file with some 800 fileds, But we only use 5 fileds in our DataStage job. I was wondering if it is possible to read only those 5 fields from my input file? If we can not read only 5 fields, Can I import the metadata from fixed width file? Please advise.

Thanks in advance

You have to read past all the fields, for such is the nature of sequential file access, but you can set the "drop on import" property for those that you do not require in the job.

Thanks for the response ray, You are saying we can import metadata from fixed width file.. Can you please tell which option I should select while importing.. I tried seq file definitions did not work.
Thanks again..

That would be the proper choice, what "did not work" about it?

Check "fixed width format" check box on the Format tab, then supply a delimited list (spaces or commas) of the column widths in the column widths field.