View previous topic :: View next topic
|
Author |
Message |
ManSab
New User
Joined: 23 Sep 2006 Posts: 13 Location: Pune
|
|
|
|
Generally when we write the SQL query in COBOL program we do not prefix the qualifier (owner) name along with the table name. If we have to access 2 tables which belong to 2 differnet owners then how to specify that and where? |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi ,
If you want access the two tables with different schema in your query then you will have to explicitly specify the schema name for table in query itself .
Code: |
select * from schema1.table1 where col1 in ( select col1 from schema2.table2 ) ; |
Regards
Senthil |
|
Back to top |
|
|
Shobana Bhaskar
New User
Joined: 02 Mar 2007 Posts: 35 Location: Pennsylvania, US
|
|
|
|
Hi,
In Cobol program, we cannot specify qualifier. Instead you should bind your program to the appropriate plan. You will have package collections that belongs to different regions. You should make use of the plan name for respective region while executing the program (through JCL - DSNPARM). |
|
Back to top |
|
|
|