Fixed width file metadata

mekrreddy · Post by **mekrreddy** » Thu Dec 29, 2011 4:21 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Dec 29, 2011 5:00 pm

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.

mekrreddy · Post by **mekrreddy** » Thu Dec 29, 2011 11:55 pm

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..

chulett · Post by **chulett** » Fri Dec 30, 2011 7:29 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Dec 30, 2011 4:27 pm

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.