Extracting From Cobol file

ds2000 · Post by **ds2000** » Tue May 20, 2008 2:39 pm

How to load cobol file schema although i have ftp'ed the shcema file from mainframe and it has all different levels of data i.e level 10, 05, 20 etc.
How can i output all level of data into a sequential file ?

ray.wurlod · Post by **ray.wurlod** » Tue May 20, 2008 4:40 pm

Import the COBOL file definition as a table definition. You can now read the data using a Complex Flat File stage or, indeed, a Sequential File stage.

vmcburney · Post by **vmcburney** » Tue May 20, 2008 11:12 pm

After you import your cobol file definition you will need to flatten the data. DataStage will turn the hierarchy information in the complex flat file into relational data tables so you need to flatten out one branch of the hierarchy at a time.