Page 1 of 1

How to extract data from Mainframes IMS & VSAM data

Posted: Sun Aug 24, 2008 3:06 am
by 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

Posted: Sun Aug 24, 2008 3:45 am
by 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.

Posted: Sun Aug 24, 2008 8:03 am
by chulett
That happy man is "C:D".

Posted: Sun Aug 24, 2008 8:11 am
by 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 :)

extracting data from Mainframes IMS & VSAM database

Posted: Mon Aug 25, 2008 1:10 am
by 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

Posted: Mon Aug 25, 2008 2:26 am
by 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?