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

SELECTing from multiple databases?

P: n/a
Hi,

I'm running DB2 V 7.1 and I wish to write a SELECT query that queries
tables in multiple tables in different databases on the same instance.
Is this possible and if so, what should the FROM clause look like?

Thanks for your help...

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Andy S. wrote:
Hi,

I'm running DB2 V 7.1 and I wish to write a SELECT query that queries
tables in multiple tables in different databases on the same instance.
Is this possible and if so, what should the FROM clause look like?

Thanks for your help...

Yes thsi is possible. First you have to do:
UPDATE DBM CFG USING FEDERATED YES
Then you need to familiarize yourself with the concept of "NICKNAME"s
You may want to start here for a read:
http://www-128.ibm.com/developerwork...06purnell.html
(there is tons of information on deleveloperWorks, but DB2 V7.1 is quite
dusty ...)

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

This discussion thread is closed

Replies have been disabled for this discussion.