MVSFORUMS.com

pradeepg

Hi,

Is there a way I can find out to which PLAN or COLLID the program belongs at run time. Any DB2 reserve words ?? I don't think I can get this in SQLCA. Based on the PLAN/COLLID I can decide if it is a batch or online program. So I am trying to find out is there a way to findout the plan name or collid of the program at runtime.

Thanks in advance.

- Pradeep

chandrankk · Beginner Joined: 06 Dec 2005 Posts: 8 Topics: 0

Try this

EXEC SQL
VALUES(CURRENT PACKAGESET)
INTO(:HV1)

your host variable should have the collection id. I think, there are some limitations for using this like if the program is running from a remote location, you may not get the proper value.

regards.

kolusu · Posted: Wed Dec 07, 2005 6:29 am Post subject:

pradeepg · Posted: Wed Dec 07, 2005 1:34 pm Post subject:

kolusu,

The code you provided can be used in calling programs also right. Will it work in lower level programs.

Chandrankk,

CURRENT PACKAGESET will have blank initially isn't it ???
because I am getting blank in the host variable. I think manual also says that, only after you set this special register with some value then it will have a value other wise it will be blank. OR did I understand it wrong?

Manas Biswal · Posted: Wed Dec 07, 2005 5:05 pm Post subject:

pradeepg,