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 |
How does DB2 determine what lock-size to use?
Suppose if I need to update a column, how you do that using cursor?
What is the size of a data page?
What is a correlated sub query?
what is the maximum number of tables that can be joined ?
What is with ur in db2?
What is copy pending status in db2?
What is COPY PENDING status?
What is a bind card?
How do I copy a table in db2?
How is deadlock resolved?
Why select is not preferred in embedded sql programs?