All,


I have a query where I am trying to join tables from different databases
using 3 part table name

for e.g.

<Database>.<Schemea>.<Table>

Table 1 : R2:dbsc:tabA
Table 2 : R4:dbsc:tabB

I am running query from R2 Database, and I can access R4:dbsc:tabB
as SELECT * FROM R4:dbsc:tabB ;

while I join the 2 tables:
as

SELECT * FROM R4:dbsc:tabB AS tabB, R2:dbsc:tabA as TabA
WHERE tabB.ID = TabA.ID

This throws error as :
SQL10007 : reason code "105"............

Is it that we can not join tables in different databases or we have some differnet way.


Thanks,
Abhijeet

Which DB2 version and OS are you using?

Andy

in db2 we never 3 part names. if the remote db is also db2 you can define nicknames. these are also 2 part names as regular tables
how did you define these remote tables to the local db
distributed luw is normally not supported