hi, Bind parameters are: MEMBER - In bind package, LIRARY

what are the bind parameters?

Question Posted / amarnadh reddy

5 Answers
39624 Views
IBM, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

957

What is buffer pool?

1028

Define data page.

1011

What is dclgen in db2?

1081

Is ibm db2 open source?

1012

How do you concatenate the firstname and lastname from emp table to give a complete name?

1011

Name the various locking levels available?

1035

What is check constraint in db2?

1011

What is the difference between spufi and qmf?

1053

What are host variables in db2?

991

Discuss about db2 bind?

1048

Why do we bind in db2?

1139

What is a dbrm in db2?

968

Explain package in db2 and its advantages?

1133

How do I create a view in db2?

972