You need to install ORACLE gateway for DB2. Then you can right a single
query
which retrieve data from DB2 and ORACLE.



-----Original Message-----
From: Aggarwal Amit (CEI)
[mailto:oracledba-ezmlmshield-x41496734.[Email address protected]
Sent: Tuesday, August 31, 2004 1:15 PM
To: LazyDBA Discussion
Subject: How to get data from Oracle and DB2 in a single SQL query


Hello

I have an Oracle Database and a DB2 database. I want to run a query
connecting in Oracle database pulling some data from Oracle and some from
DB2 in a single query. How can I do it.

Can I create a DB Link pointing to DB2. If not what would be a good way. I
can connect to each database individually using ODBC but the problem is I
can't connect to both databases together.

Thanks
Amit


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page