Unanswered: Loading Data from DB2 on mainframe to Oracle and regular update
We have a DB2 database on Mainframe and a Oracle DB on Unix box.
We are trying to extract some of the table data from DB2 to Oracle. What is the best way to do so? Is there any way to copy the table structures too? I heard using DB2 ODBC driver we can access data from Oracle, but not sure how? Can any one please explain in detail how I can do that?
We also want to update these oracle tables in regular intervals with the changes done on DB2 data. Which is the best way to do so?
I would appreciate if any one can give me a solution.