Creating Mainframe jobs

aaikat · Post by **aaikat** » Thu Aug 10, 2006 6:58 am

Please let me know whether I can extract data from MVS database & transform it using a Parallel job or I need to create a Mainframe job for that.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 10, 2006 7:03 am

It can be done, but the politics of getting access to the mainframe system usually means that they produce an extract (using a COBOL program or SQL) into a text file and FTP that to some location that you can process.

You do not specifically require a DataStage mainframe job. Of course, if you do have an edition of DataStage that can create a mainframe job, you can generate the COBOL program that "they" can run on your behalf. This might also look after the FTP phase.

aaikat · Post by **aaikat** » Thu Aug 10, 2006 7:19 am

So,extracting (using COBOL or SQL) MVS data into file & FTP that to some location can be done from Parallel job itself. Right?

meena · Post by **meena** » Thu Aug 10, 2006 8:00 am

Hi aaikat...
Yes, you can design a parallel job..I design a server job where we get the data in CFF file...

aaikat wrote:So,extracting (using COBOL or SQL) MVS data into file & FTP that to some location can be done from Parallel job itself. Right?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 10, 2006 8:14 am

It's by far the most common solution. It means you don't have to be given access to their precious mainframe!

meena · Post by **meena** » Thu Aug 10, 2006 8:21 am

Yes.....