By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

join 2 databases

P: n/a
Hi,

DB2 V6.1 on windows

How can I write a query that join two tables in a different database (but
same instance).

Thanks

*** Sent From/Enviado desde: http://groups.expo.st ***
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
haezeban wrote:
Hi,

DB2 V6.1 on windows

How can I write a query that join two tables in a different database (but
same instance).


Have a look at DB2's federated capabilities. However, for that you want to
upgrade to V8 (or V7) - V6 is out of services for a few years now.

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
haezeban wrote:
Hi,

DB2 V6.1 on windows

How can I write a query that join two tables in a different database
(but same instance).

Thanks

*** Sent From/Enviado desde: http://groups.expo.st ***

In DB2 V6.1 - no can do. This function was available in "Datajoiner".
Datajoiner was first merged into the DB2 codebase in DB2 V7 known as
"relational connect" IIRC.
Your best bet on V6.1 would be a connect type 2 which allows for
distributed transactions.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.