mf_user Intermediate
Joined: 01 Jun 2003 Posts: 372 Topics: 105
|
Posted: Mon Dec 03, 2007 8:13 am Post subject: new company / new project |
|
|
Hi,
The question is to find out the parameters to be used for Package or Plan BIND. We joined a new project where DB2 is used. How to know the below given params by ourselves? Is it useful to query SYSIBM tables to get the same?
Code: |
//SYSTSIN DD *
DSN SYSTEM(XXXX)
BIND PACKAGE(XXXXXXX) -
OWNER(XXXXXXXX) -
QUALIFIER(XXXXXXX) -
MEMBER (XXXXXXXX) -
VALIDATE(BIND) -
CURRENTDATA(NO) -
EXPLAIN(YES) -
RELEASE(COMMIT) -
ACTION(REPLACE) -
ISOLATION(CS)
/*
//SYSTSIN DD *
BIND PLAN(XXXXXXXX) -
OWNER(XXXXXXXX) -
PKLIST(XXXXXXX.*) -
QUALIFIER(XXXXXXX) -
ACQUIRE(USE) -
RELEASE(COMMIT) -
CURRENTDATA(NO) -
ACTION(REPLACE) RETAIN -
ISOLATION(CS);
/*
|
Also, would like to know how the package and plan BIND card will differ if any sub-program call is involved.
Please explain.
Thanks. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|