IBM DB2 Question:
Download Job Interview Questions and Answers PDF
what are the bind parameters IBM DB2?
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? |