Hi,
Using datastage can I to ETL from DB2 to IMS?
I know I can surely extract from DB2.
So the left part is, can I load in IMS using DataStage?
DB2 to IMS
Moderators: chulett, rschirm, roy
Re: DB2 to IMS
The "from DB2" part, as you have noted, is of course doable. "To IMS", can't really be done (90% sure) directly, but I would think we can output data in IMS format to a file and load it into mainframe using NDM.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage *can* work with IMS datasets and viewsets. But you will need to use a "mainframe" job (extra cost) to do so. As the name suggests, a mainframe job runs on the mainframe - DataStage generates COBOL source plus JCL to compile and run the same.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.