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



DB2 & UDB email list listserv db2-l LazyDBA home page