How to Import Mainframe(cobol)file into DataStage

sasikiran · Post by **sasikiran** » Mon Mar 27, 2006 8:35 am

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

chulett · Post by **chulett** » Mon Mar 27, 2006 9:17 am

CFF or Complex Flat File stage... assuming .CPP is some sort of copybook type file holding a COBOL FD.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 27, 2006 2:51 pm

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.