-
Table access between databases
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!
-
Re: Table access between databases
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|