Joining across Databases in AIX 1

[dja1]

I have two separate databases contained in the same Instance, (DB2 running under AIX).

I use SQL emdedded in COBOL programs.

Can I use SQL statements that join tables in both databases. If so, how do I "connect" them?

 

[grofaty]

Hi,

Acording to my knowleage it is only posible with federated database aproach.

Hope this helps.
Grofaty

 

[dja1]

Grofaty

Thanks very much for you reply

 

[gregsimpson]

Dave,

look up 3 part names.

location.creator.name

Try the following

http://www-3.ibm.com/software/data/

db2/os390/techdocs/os23.pdf

Never done it on AIX but it works fine on mainframe. I'll try and dig out an example.

Cheers
Greg