Hi,
We are developing an application may access ORACLE or DB2. For
our application there will be a Schema, dedicated specifically to it
only. Let Us Call this Schema as SCH1. It will have 7 tables. Tab1 to
Tab7. In Oracle we can write the query

Select SCH1.Tab1.* from SCH1.Tab1 where SCH.Tab1..........

This will return columns from Tab1 in SCH1. Please note that there
might be Tables named Tab1 in other Schemas also. And there definetly
will be other Schemas in the Database. Similarly we can get details
from other Tables in Schema1, by simply replacing the "Tab1" with
"Tab2", "Tab3", and so on.

My question is this, will the above mentioned Query work with IBM
DB2? Or will I have to write a "SET CURRENT SCHEMA=SCH1" and then
write the query.

Thanks in Advance for your help
Amardeep Verma

Amardeep Verma <addverma (AT) email (DOT) com> wrote:

The query will work as shown above.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena