what are the bind parameters?
Answers were Sorted based on User's Feedback
Answer / amarnadh reddy
hi,
Bind parameters are:
MEMBER - In bind package,
LIRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
AQUIRE - Lock a tableon use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
in table
Is This Answer Correct ? | 41 Yes | 2 No |
Answer / ranju
One more important BIND parameter.
'OWNER' That is the table creator name,which specifies the
table needs to be accessed is dev,UAT or Prod
Is This Answer Correct ? | 22 Yes | 1 No |
Answer / ram
Bind Parameters are below...
Bind Package/Plan
Owner (Authorization ID)
Qualifier (qualifier name)
Member (member name)
Library (DBRM Pds name)
ACTION (ADD/REPLACE)
Explain (Yes/No)
Flag (I/W/E/C)
ISOLATION (RR/RS/CS/UR)
Release (Commit/Deallocate)
Validate(Run/Bind)
Acquire(Use/Allocate)
Is This Answer Correct ? | 10 Yes | 0 No |
what is a collection?
What is the purpose of the WHENEVER statement?
What is the difference between IN subselects and EXISTS subselect?
How is the SUBSTR keyword used in sql?
What is the use of db2?
What is dpf in db2?
What is IMAGECOPY ?
What is difference between *omit and *nopass?
Q3. How will you fetch duplicate values from a DB2 table?
what is consistency token
what is the use of cursors?
How many databases are there?