Question on PACKAGE/PLAN

balubhat · New User Joined: 04 Oct 2005 Posts: 19 Location: Singapore

Hi All

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.

Thanks.

dbzTHEdinosauer · Posted: Mon Nov 09, 2009 6:33 pm

suggest you create a new module.

Ronald Burr · Posted: Mon Nov 09, 2009 7:56 pm

Try specifying the non-default qualifier explicitly when you reference the table - for example

wanderer · Posted: Tue Nov 10, 2009 5:06 am

Or create a view with select * under schema A001. on the base table A002 and use the view instead.

dbzTHEdinosauer · Posted: Tue Nov 10, 2009 5:09 am

deleted by dbz

rahulcherekar · New User Joined: 20 Feb 2007 Posts: 16 Location: New York

Creating synonym should solve your problem. If you do not have authority check with your DBAs.

Thanks,
Rahul.

Anand Kumar · New User Joined: 29 Aug 2007 Posts: 24 Location: chennai

We had a couple of issues, similar to yours. We solved in creating a synonym. We should make sure the proper privilege is given to the user Read/Write/update

sachin_star3 · New User Joined: 30 Sep 2006 Posts: 78 Location: pune

you can deal with your issue using following 2 ways.

1.create 2 different package with seperate hlq and bind in the single plan.

2.hard either any one table in hlq and put the other table hlq in the package bind