Interview Questions   Tutorials   Discussions   Programs   

DB2 - What are the bind parameters?

asked mar August 3, 2014 06:38 AM  

What are the bind parameters?


1 Answers

answered By Mswami   0  
Bind parameters are:

MEMBER - In bind package,
LIBRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
ACQUIRE - Lock a table on use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
OWNER - the table creator name.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!