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 |
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is a cursor and what is its function?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is temporal table in db2?
What is bind plan?
What's The Error Code For Unique Index Voilation?
How is the value function used?
What is meant by dclgen?
is there any restrictions for unions ?
How do I copy a table in db2?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is db2? Explain.