Page 1 of 1

How to Import Mainframe(cobol)file into DataStage

Posted: Mon Mar 27, 2006 8:35 am
by sasikiran
Hi,

We are trying to import Mainframe(.CPPfile)file into Datastage, how to do that? is there any pirticular stage to do this.


Thanks & Regards

Sas

Posted: Mon Mar 27, 2006 9:17 am
by chulett
CFF or Complex Flat File stage... assuming .CPP is some sort of copybook type file holding a COBOL FD.

Posted: Mon Mar 27, 2006 2:51 pm
by ray.wurlod
You need to import the metadata first. In Manager choose Import > Table Definition then choose COBOL FD (or DCLGen, if that's what you have) from the list of available sources. For a COBOL FD table definition you must provide the column number in which the 01 level item appears.

Once you've done that, you will find that a simple file can be read with a Sequential File stage (having loaded the metadata), while a more complex file can be read with a Complex Flat File stage.