Interested to Buy Any Domain ? << Click Here >> for more details...
what are the bind parameters?
- 5 Answers
- 39986 Views
- IBM, I also Faced
- E-Mail Answers
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 Reorg Recovery? when will you run it?
How to fetch the last row from the table in SQL (db2)?
How can record locking be achieved in those DB2 versions which do not support it?
What is an access path?
What is rct?
How to compare data between two tables in db2?
What are the different types of base tables?
What is a clustering index?
If I have a view which is a join of two or more tables, can this view be updatable?
How is the value function used?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
COBOL 
