Answer Posted / 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 |
Post New Answer View All Answers
define clustering index.
What is a collection in db2?
How to check last update on table in db2?
What is ibm db2 used for?
Explain what are the various isolation levels possible?
What is the physical storage length of time data type?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do you select a row using indexes in db2?
What is the maximum No of rows per page?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the various isolation levels possible?
What is the difference between plan and package in db2?
What is cursor with hold option in db2?
What is rct?
What are host variables in db2?
