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

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

Are view updateable?

0 Answers  

What are the benefits of using the db2 database?

0 Answers  

What is Call attach facility? How does it work?

1 Answers   Syntel,

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

What do you do to keep the cursor from closing after a commit?

1 Answers  

What is reorg?

0 Answers  

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

How to check last update on table in db2?

0 Answers