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?
Joined: 02 Mar 2007 Posts: 35 Location: Pennsylvania, US
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).