Table access between databases

[jcale4]

HI,

Is there a way in DB2 to access table data (within the same schema) in another database? I tried using schema.database.tablename - didnt work.

Thanks!

[harry_blr]

In Db2 ur having diff schema's in a database.. U might be confused between schema & database..

If you wants to access tables of diff schema in same database, then the solution is as follows:

Try using schemaname.tablename , as ur in the same schema.. so no need to prefix schema name ..
Ex:
schema1: table1, table2
schema2: table3, table4

Select * from schema2.table4;

select * from schema1.table1


If you wants to access tables in diff database, u need to catalog that database n use CONNECT to DATABASE command , while remain in the same box.