MVSFORUMS.com

chikdu · Beginner Joined: 06 Jul 2005 Posts: 29 Topics: 20

Hi,

I wanted to know which all bind parameters are required for the efficent execution of a db2 program.

Our application is using the following bind parameters:
BIND PACKAGE (PYRLCOL) -
MEMBER (P010) -
ISOLATION (CS) -
VALIDATE (BIND) -
RELEASE (COMMIT) -
EXPLAIN (YES) -
CURRENTDATA (NO) -
DEGREE (ANY) -
DYNAMICRULES (BIND) -
SQLERROR (NOPACKAGE) -
ACTION (REPLACE) -
FLAG (I) -
QUALIFIER (MM01) -
OWNER (MM01)
END

Are all these parameters required? Also, is the ACQUIRE,FLAG and NODEFER parameters required? I have come across these parameteres in another application.

Kindly,let me know.

kolusu · Posted: Tue Jul 12, 2005 5:50 am Post subject:

chikdu,

Check this link which explains all the bind parameters in detail.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAGH10/5.7.5.4?SHELF=&DT=20010212102121&CASE=

Hope this helps...

Cheers

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

chikdu · Beginner Joined: 06 Jul 2005 Posts: 29 Topics: 20

Thanks for the link, Kolusu.