Page 1 of 1
Extracting From Cobol file
Posted: Tue May 20, 2008 2:39 pm
by ds2000
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 ?
Posted: Tue May 20, 2008 4:40 pm
by ray.wurlod
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.
Posted: Tue May 20, 2008 11:12 pm
by vmcburney
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.