How to extract data from Mainframes IMS & VSAM data

[dashamukhi]

Hi,
I want to extract data from Mainframes IMS and VSAM data and load to the same formats using parallel job. Please advice me what intermediate stage to be used between Source and Tagfet stages?

My requirements is : SRC (Mainframe)----> stage ---->TGT (Mainframe)

Thanks in advance

[ArndW]

There is a version of DataStage that runs on the mainframe which is the best choice for this; otherwise you will need to ensure that FTP, C:D or other method exists with which the data can be transferred from and to the host in order for it to be processed by DataStage.

[chulett]

That happy man is "C:D".

[ArndW]

Craig - thanks for that. I would have gone back and corrected my post to disable smilies, but then your corrective post would have made absolutely no sense at all

[dashamukhi]

Thanks Arnd,

the data in IMS is of 80's and version of IMS database is 1.0. I think the present vesion is 8.0 if i am not wrong. We do need to filter the records at the time of extraction. Can we use Complex Flat file stage for this requirement? any idea? I never used CFF stage.

Thanks again

[ArndW]

Complex Flat Files read and parse COBOL structures. But first you need to get the data from your host to the UNIX DataStage server and you need to send them back after processing. Do you have a method arranged to do this transfer?