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
What is db2 and what is the use of db2 optimizer?
How to check last update on table in db2?
How to find the maximum value in a column in the db2 database?
How to fetch the last row from the table in SQL (db2)?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is a db2 schema?
What is difference between rollback and commit?
What is copy pending and check pending in db2?
What is page size in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is runstats utility in db2?
What are host variables in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is drop table?
What is temporal table in db2?