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%[email protected]>, Victor Gil <[email protected]> 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. > > On Thu, 17 Sep 2009 11:36:45 -0400, Don Leahy <[email protected]> > wrote: > >>FWIW, I usually specify the plan via a PARM. Would this not suit your > purpose? > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html >>> The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. Thank you. -- Frank Swarbrick Applications Architect - Mainframe Applications Development FirstBank Data Corporation - Lakewood, CO USA P: 303-235-1403 ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
