IBM DB2 Question: Download Questions PDF
what are the bind parameters IBM DB2?
![IBM DB2 Interview Answer IBM DB2 Interview Question](https://globalguideline.com/public/images/interview/30.png)
Answer:
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
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
Download IBM DB2 Interview Questions And Answers
PDF
Previous Question | Next Question |
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why? | What is sqlcode -811? |