Update table on Oracle from DB2 database

ddempsey · #1 (**permalink**) 06-01-04, 05:15

Hi,

I need to know what is the easiest way to update an oracle table from db2 database. If i was updating a db2 table from oracle, then i could use gateways in oracle. Is there something similar in DB2.

Ideally i would liek to be able to call an oracle stored procedure from a db2 stored procedure. I don't know if this is possible.

Thanks,
Dave

J Petruk · #2 (**permalink**) 06-01-04, 09:25

Quote:

Originally Posted by ddempsey

Hi,

I need to know what is the easiest way to update an oracle table from db2 database. If i was updating a db2 table from oracle, then i could use gateways in oracle. Is there something similar in DB2.

Ideally i would liek to be able to call an oracle stored procedure from a db2 stored procedure. I don't know if this is possible.

Thanks,
Dave

I suspect you're looking for federated database support. (Formerly DataJoiner)

Internet Services

Web Development

Digital Marketing

Consumer Tech