Interested to Buy Any Domain ? << Click Here >> for more details...
what are the bind parameters?
- 5 Answers
- 39955 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 the difference between plan and package in db2?
What is the maximum size of varchar data type in db2?
What is the use of db2?
Where do you specify them?
What is image copy?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
what is utility for parm lib
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is a thread?
What is a DB2 catalog?
What is meant by explain?
What is the use of dclgen in db2?
COBOL 
