I have a stand alone COBOL-DB2 program and I have many embedded SQL in the program. Due to some requirement I have to embed a new SQL for which the qualifier of the table is different than all other tables used in the program. i.e. all my existing SQLs refer to the table with qualifier as A001.<TABLE_NAME>. But now with my new SQL , I have to refer to a table with qualifier A002.
In the program we don't mention the qualifier but in the PACKAGE we give the qualifier.
Now my question is how can I compile and BIND this program for two different qualifier?
Pls help me.