Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Obtaining plan name from within an executing cobol program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
gjdeluca

New User


Joined: 05 Oct 2006
Posts: 1

PostPosted: Sat Oct 04, 2008 6:42 am    Post subject: Obtaining plan name from within an executing cobol program
Reply with quote

Is there a way to obtain the name of the plan that is being used from within an executing COBOL/DB2 program. More specifically, I need to obtain the Table Qualifier that is being used by the Plan.

One program is written to access DB2 tables. The program is used in several job streams and each job stream uses a different table qualifier to access its tables.

So several plans are created for the one program. Each plan has the qualifier that is to be used for that plan.

When the program is executing, I want to be able to determine what qualifier is being used (or what plan is being used).

I know I can use a parm to be passed to the program, but I want a more dynamic solution that ensures accurate information. The parm could be coded incorrectly, whereas the actual qualifier being used is indisputable.
Back to top
View user's profile Send private message
References
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1