Answer / 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

Answer / ranju

One more important BIND parameter.
'OWNER' That is the table creator name,which specifies the
table needs to be accessed is dev,UAT or Prod

Answer / ram

Bind Parameters are below...

Bind Package/Plan
Owner (Authorization ID)
Qualifier (qualifier name)
Member (member name)
Library (DBRM Pds name)
ACTION (ADD/REPLACE)
Explain (Yes/No)
Flag (I/W/E/C)
ISOLATION (RR/RS/CS/UR)
Release (Commit/Deallocate)
Validate(Run/Bind)
Acquire(Use/Allocate)

Answer / harsha

and VERSION --- for different versions to bind

Answer / saloni

QUALIFIER

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

how to fetch first 100 rows in db2

2 Answers   IBM,

how to resolve -805. give clear explination for that

2 Answers   IBM,

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

How can you compare table column after update and before update?

5 Answers   Satyam,

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

What does db2 mean?

0 Answers  

Compare a subselect to a join?

1 Answers  

What are the four lockable units for DB2?

1 Answers  

Can you access the DB2 Directory table using SQL?

3 Answers  

What is the FREE command?

1 Answers