You can federate the 2 databases. Search previous mail threads in LazyDBA
on keywords FEDERATE or FEDERATION.
You'll find document links and examples.
Regards
Alex Levy
Sustainable Software Ltd.
________
"Pham Anh "
<db2udbdba-ezmlms
hield-x25695214.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
28/07/2006 13:21
Subject
RE: Accessing data from different
database on different location
I thought we would be correct to say that we could join the query at the
schema level (e.g within 1 DB only)
I have not known the way you could do db1.tab1 ?
It should be schema.tab1 after you already connect to 1 DB -
..A.P
-----Original Message-----
From: Singh Rahul
[mailto:db2udbdba-ezmlmshield-x76606698.[Email address protected]
Sent: July 28, 2006 8:15 AM
To: LazyDBA Discussion
Subject: RE: Accessing data from different database on different
location
Are you sure you can fetch data from a join from tables on two different DB
at two different server.
When you connect through command window or command editor it only allows
you to connect to only one DB at one time.
But I am not sure as I have little knowledge on advance topics of db2.
Correct me if I am wrong
Rahul
-----Original Message-----
From: Jitendra Kumar Prajapati
[mailto:db2udbdba-ezmlmshield-x68231816.[Email address protected]
Sent: Friday, July 28, 2006 5:35 PM
To: LazyDBA Discussion
Subject: Accessing data from different database on different location
Hi DBAs,
I've joined LazyDBA once again.
I have two different databases on two different locations and I want to
query data from both the database servers.
Select * from db1.tab1 tab1, db2.tab2 tab2
Where tab1.col1 = tab2.col1;
So, kindly advise me the better way to achieve it.
Any help would be highly appreciated.
Thanks and Regards,
Jitendra Kumar Prajapati
============================================================================================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a href="http://www.techmahindra.com/Disclaimer.html
">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
http://tim.techmahindra.com/Disclaimer.html
">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
Mahindra.
============================================================================================================================
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page