IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Obtaining plan name from within an executing cobol program

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
gjdeluca



Joined: 05 Oct 2006
Posts: 1

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

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  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM