Re: Connect Oracle & Db2

If I'm not mistaken Oracle did a seminar on this about 1.5 years ago. (It was using an AS/400
running DB2 ) I'm assuming it shouldn't change to much with VMS since SQL should take care
of all the comms between both databases.

What it came down to was have a live connection between both databases. Oracle
suggested using SQL*Net 2.0 or above. (It seems to be compatible to DB2 and I believe
there's a version for MVS). This way using standard SQL statements the transfer of
data from both databases can be made effortles via the apps or in batches. The SQL statements
can be launched from either platform...

Good Luck..
Uri Margalit <urimr_at_ibm.net> wrote in article <337d8445.169072_at_news.ibm.net.il>...
> Hello!
>
> We need to propogate data from DB2 MVS/ESA to Oracle (UNIX/NT).
> The tables are big and I don't want to propogate al the tables
> evreytime, I want only propogate the changes. I use DPROP to propogate
> the tables from DB2 to DB2, but which tool can I use to propogate from
> DB2 to Oracle. I also need to propogate from Oracle to DB2, which tool
> can do that ?
>
> Help will be appriciate.
>
>
> Uri Margalit.
>
> Please email
> me to urimr_at_ibm.net
>
>
Received on Mon May 26 1997 - 00:00:00 CDT