IBM DB2 Question:

Download Job Interview Questions and Answers PDF

what are the bind parameters IBM DB2?

IBM DB2 Interview Question
IBM DB2 Interview Question

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

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext 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?