|
View previous topic :: View next topic
|
| Author |
Message |
jzhardy
Active User
Joined: 31 Oct 2006
Posts: 139
Location: brisbane
|
|
|
|
does anyone have any COBOL (or SQL) to read the current (batch) application plan.
I've tried reading off 'current packageset' but this is blank.
Or is there some API to Z/OS ? |
|
| Back to top |
|
 |
jzhardy
Active User
Joined: 31 Oct 2006
Posts: 139
Location: brisbane
|
|
|
|
I’m trying to connect to db2 via DSNRLI
Here I invoke the thread:
| Code: |
CALL 'DSNRLI' USING CRTHRDFN PLAN
COLLID REUSE
RETCODE REASCODE. |
PLAN (above) is the batch application plan
Then within this module I call the actual program (CLL-PROGRAM). It’s in this program that I need to access PLAN - however, I can't modify the imports to CLL-PROGRAM.
| Code: |
CALL CLL-PROGRAM USING
WS-IEF-INPUT-PARM1
WS-IEF-INPUT-PARM2
WS-GLOBDATA
MOVE RETURN-CODE TO SAVE-RETURN-CODE |
Is there a way I get can properties off the current RRSAF thread |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
And why would ever program needs to. Know the Db2 plan ?
Btw one way is you can query SYSIBM.SYSPACKAGE based on program name to get COLLID and then use that to query SYSIBM.SYSPACKLIST to get the Plan or join them in one query. |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| topic moved and cleansed. The duplicate has been deleted. |
|
| Back to top |
|
|
|
|
