Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what are the bind parameters?

Answers were Sorted based on User's Feedback



what are the bind parameters?..

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

Is This Answer Correct ?    41 Yes 2 No

what are the bind parameters?..

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

Is This Answer Correct ?    22 Yes 1 No

what are the bind parameters?..

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)

Is This Answer Correct ?    10 Yes 0 No

what are the bind parameters?..

Answer / harsha

and VERSION --- for different versions to bind

Is This Answer Correct ?    10 Yes 3 No

what are the bind parameters?..

Answer / saloni

QUALIFIER

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is the difference between plan and package in db2?

0 Answers  


What is the maximum size of varchar data type in db2?

0 Answers  


What is the use of db2?

0 Answers  


Where do you specify them?

0 Answers  


What is image copy?

1 Answers   Virtusa,


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


what is utility for parm lib

0 Answers   IBM,


If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,


What is a thread?

3 Answers  


What is a DB2 catalog?

2 Answers  


What is meant by explain?

0 Answers  


What is the use of dclgen in db2?

0 Answers  


Categories