DB2 Ver 8.

Can we build Queries across two Databases. For ex : on two diff tables existing in two diff DB's.

Table P1 in DB test1 and Table P2 in DB Test2. ?

If so how ?

I know of Federated DB's, but wondering is there any other way ?

Thanks in advance,

Information which need to passed to the above ..

This two db's on the Same platform. Win Platform..

If the two tables referenced are in the same SQL statement, you need federated support.

Thanks Marcus for the prompt reply..Am wondering is there anything other then federated DB support..like using alias can we build a query based on two different db's.

No, not if the two tables are in the same SQL statement. However, one can connect to two different databases in the same program, but you would need separate SQL statements to access them.

When there is any chance that tables might need to be accessed in the same SQL statement, they should be in the same database, but perhaps different schemas if they need to be logically separated. Having two databases active on the same machine at the same time is not very efficient because it limits the amount of memory that can be used by any one database.