I have a application where one module is developed with Oracle database and other module is developed with DB2 database. I have to create a tool which will compare common entries in tables of the 2 databases.
How can I compare the entries in tables of the databases? I have to achieve the result using servlets.
Please guide me.
A prompt response will be highly appreciated.
Thanks in Advance!
--DD
-
DB2 and Oracle with servlet help (1 messages)
- Posted by: Dhiren Kumar
- Posted on: November 02 2004 05:53 EST
Threaded Messages (1)
- Let SQL Take the Strain by Duncan Mills on November 05 2004 00:17 EST
-
Let SQL Take the Strain[ Go to top ]
- Posted by: Duncan Mills
- Posted on: November 05 2004 00:17 EST
- in response to Dhiren Kumar
To tell the truth the simplest way to do this is to use a product that will let you Join across the two databases and then use a select ... from oracletable INTERSECT select ... from db2table.
The way I know of doing this would involve using a database link from Oracle to DB2 via the relevant transparent gateway (see http://www.oracle.com/technology/products/gateways/index.html) . This is all from the Oracle driving direction, although you could always to the same thing in reverse from DB2 I suspect