This I can't do, sorry. But here's a pointer to the doc on DB2's "Call Attachment Facility" [CAF] that has all the required information [watch the wrap!]:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnapj15/6.7? SHELF=DSNSHJA8.bks&DT=20080201235049 You may get a better answer on the DB2 forum. -Victor- On Thu, 17 Sep 2009 18:40:19 -0600, Frank Swarbrick <frank.swarbr...@efirstbank.com> wrote: >This sounds almost ideal. >It seems to me that DB2 should allow for a user exit that is called the first time DSNHLI (DSNALI?) is called. If they did this, and documented it well, then we wouldn't have 20 zillion people having to solve this same issue over and over. > >Anyway, being what it is, and since you were so kind to share with me your DSNAME code, I don't suppose you'd be able to share with me your DSNHLI code as well...? > >Thanks, >Frank > >On 9/17/2009 at 9:56 AM, in message ><listserv%200909171056561145.0...@bama.ua.edu>, Victor Gil ><victor....@broadridge.com> wrote: >> The way our applications DB2 programs are coded is - they know nothing >> about the plan [or even about the DB2 subsytem to connect to]. All the have >> is the SQL logic. On a first SQL call a homegrown DSNHLI subroutine >> determines all the required parameters [that are NOT passed on the SQL call >> and the subroutine has no access to the EXEC PARM!], issues a connect and >> opens the plan. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html