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 is a DB2 bind?



What is a DB2 bind?..

Answer / tintu raveendran

It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More DB2 Interview Questions

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,


Explain the use of the WHERE clause.

2 Answers   IBM,


What are the three lock types?

2 Answers  


How can you get the number of rows impacted by the last executed query?

1 Answers  


what are bind concepts in db2 cobol?

0 Answers  


How can you quickly find out the # of rows updated after an update statement?

0 Answers  


What is nvl in db2?

0 Answers  


What is a SELECT statement?

1 Answers  


What does db2 mean?

0 Answers  


How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  


Categories