Cross-Database join

[PawelTru]

I am trying to access date in second database using stored procedure that is called from the first database. Both databses are located on the same server.
In MS-SQL it was simmple you just do:
Select * from DB2.DBO.TABLENAME

How do you do similar select statement in DB2.

Thank You

 

[PawelTru]

I am running version 8.1 on Windows 2000

 

[gregsimpson]

PawelTru,

I believe it works as follows

subsys2.schema.table

Cheers
Greg

 

[gregsimpson]

PawelTru,

I have also seen it as

location.creator.name

Cheers
Greg

 

[PawelTru]

When I try to set it as follow

ACCPAC.busdat.apven

ACCPAC -> location
busdat -> schema
apven -> table

it returns me a error

ADMINISTRATOR.test: 13: [IBM][CLI Driver][DB2/NT] SQL0204N "ACCPAC.BUSDAT.APVEN" is an undefined name. LINE NUMBER=13. SQLSTATE=42704