reading thro seq file stage

India2000 · Post by **India2000** » Thu Mar 15, 2012 10:01 am

Hi,

is it possible to read multiple fixed witdth flat files thro a single seq stage?How??

chulett · Post by **chulett** » Thu Mar 15, 2012 10:29 am

As long as they share the same structure / metadata, use the File Pattern option.

India2000 · Post by **India2000** » Thu Mar 15, 2012 10:52 am

no they aren't ..I'm seperating out header nd details..reading them ..

chulett · Post by **chulett** » Thu Mar 15, 2012 11:23 am

Not what I said... do they all share the same structure? Same format for headers, detail, etc with the only difference being the name of the file?

India2000 · Post by **India2000** » Thu Mar 15, 2012 11:26 am

NO..
No they are of different dml structure

chulett · Post by **chulett** » Thu Mar 15, 2012 11:37 am

Then it's up to you if you want to go to all the trouble of reading them all as one long string and then parsing each one "in job" once you determine what structure it is.

djbarham · Post by **djbarham** » Thu Mar 15, 2012 7:45 pm

India2000 wrote:no they aren't ..I'm seperating out header nd details..reading them ..

As long as each record has a record type field, you can handle different record types and multiple files using the file pattern option in the Complex Flat File stage.

India2000 · Post by **India2000** » Sun Mar 18, 2012 8:53 pm

I want to extract date value from the header for one of the columns in the output file from the fixed width flat file.I can't use the file with header with details for extracting.I want to know is there a way I can extract this header in a different file and then process.