Method to read complex flat file using sequential file?

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Thu Oct 22, 2009 7:49 am

Hi,

How do we read complex flat file using sequential file stage? I would want to generalize the job so that I can pass the variable of the schema file to the sequential file and run the job or is it possible to pass the cobol copy book at the run time as parameter and run the job?????

BMSK · Post by **BMSK** » Thu Oct 22, 2009 8:20 am

Are reading data which file?

wheter compelx or Sequential stage.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Thu Oct 22, 2009 8:43 am

I am trying to generalise the metadata definition with the help of shcema files to read complex flat files using sequential file stage

chulett · Post by **chulett** » Thu Oct 22, 2009 8:45 am

If you are asking if the Schema File property in the Sequence File stage can be parameterized, the answer is yes.

ArndW · Post by **ArndW** » Thu Oct 22, 2009 8:46 am

The definition of what a "complex" file contains is very loose. Many, if not most, COBOL structures can be read in sequential file stages. The CFF stages makes a lot of things easier to reqalize and has support for such things as "OCCURS DEPENDING ON" which the sequential file stage cannot interpret correctly.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Thu Oct 22, 2009 8:52 am

Thanks for the replies. well I just wanted to know if there is a possibility to use schema file in the complex flat file stage????

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Fri Oct 23, 2009 3:50 am

I guess I wasn't clear enough with my previous post. I meant the way we pass the schema file name during the runtime in sequential file can we do that in complex flat file to pass the cobol copy book name to the job as parameter at run time?

chulett · Post by **chulett** » Fri Oct 23, 2009 7:17 am

Or people don't know or don't feel like answering.

Does the CFF stage have a Schema File property? If so, have you tried parameterizing it?

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Fri Oct 23, 2009 7:32 am

I couldn't find it. so, that means that we can use it???

chulett · Post by **chulett** » Fri Oct 23, 2009 7:42 am

If you actually meant "can't" then it seems I would agree.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Wed Oct 28, 2009 5:58 am

is there an alternate method to achieve this? like being able to read the file using sequential file stage........

chulett · Post by **chulett** » Wed Oct 28, 2009 7:24 am

Probably... again, it really comes down to what you mean by "complex".

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Wed Oct 28, 2009 7:48 am

the file has got binary data with ebcidic character set

DSXchange

Method to read complex flat file using sequential file?

Method to read complex flat file using sequential file?

Re: Method to read complex flat file using sequential file?