View previous topic :: View next topic
|
Author |
Message |
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
Hi,
I have Table A and TableB in 2 Databases (PRD11 and PRD88) & in 2 Db2 regions ABC and XYZ respectively.
TableA : DBPPRD11.ABCDB2P.TableA
TableB : DBPPRD88.XYZDB2P.TableB
Now in the above example, the database are different and DB regions are different and my requirement is to cross these 2 tables to filter results. How do I achieve this join?
Thanks,
Arien |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you speak with your dba about which alternatives might be available for this. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Arien,
You can use db2 3 quaifier name to refer these tabes. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
arien wrote: |
Hi,
I have Table A and TableB in 2 Databases (PRD11 and PRD88) & in 2 Db2 regions ABC and XYZ respectively.
TableA : DBPPRD11.ABCDB2P.TableA
TableB : DBPPRD88.XYZDB2P.TableB
Now in the above example, the database are different and DB regions are different and my requirement is to cross these 2 tables to filter results. How do I achieve this join?
Thanks,
Arien |
some DB2 Z/OS terminology:
DBPRD11 and DBPRD88 are not databases , but SUBSYSTEMs
ABCDB2P and XYZDB2P are not regions, but SCHEMA's, OWNERs, QUALIFIERs or even CREATORs
You can not join tables from different Subsystems.
In fact : this is the same question as asked friday (only 2 -5 post lower in the overview) : ibmmainframes.com/viewtopic.php?t=51200 |
|
Back to top |
|
|
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
Thank you all. This definitely clarifies my concepts. |
|
Back to top |
|
|
|