DSXchange

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.

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.

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

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?

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

Yes.....