MVSFORUMS.com

nagasadhu · Beginner Joined: 08 Jul 2006 Posts: 17 Topics: 6

Hi

Is there a way to receive the sub-system ID in the application program?

i.e

DSN system(TDB2)
Run program(appl1) plan(appl1) lib(loadlib)
END

I want TDB2 to be available inside my program. Passing it as a PARM is one I thought but any other way of doing it ?

Thanx

PS: I use PL1 (if it matters).

kolusu · Posted: Wed Apr 25, 2007 12:42 pm Post subject:

nagasadhu,

Look up "CURRENT SQLID" in the Db2 Sql reference manual

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

bauer · Posted: Thu Apr 26, 2007 1:57 am Post subject:

nagasadhu,

try this PL1 solution: