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 functions of Bind?

Answers were Sorted based on User's Feedback



What are the functions of Bind?..

Answer / swetha dasari

there are three things bind does:

1. as stated above, it derives the most optimised path for
each SQL in the DBRM.
2. it does a syntax check. this might sound redundant, but
here is where it refers to the DB2 Catalog and verifies the
table names, column names etc.
3. it checks authorization. here is where it checks if the
user has bind access to the table refered.

Is This Answer Correct ?    4 Yes 0 No

What are the functions of Bind?..

Answer / ms. stanley

To create the most optimal path for the SQL Queries in the
program

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

How does coalesce work?

0 Answers  


What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  


What is a system catalog table in db2?

0 Answers  


What is pagespace?

1 Answers  


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


What is the physical storage length of timestamp data type?

0 Answers  


wht displays the number of times a query modified ?

2 Answers   TCS,


What is the maximum No of rows per page?

0 Answers   IBM,


What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,


What is difference between *omit and *nopass?

1 Answers   IBM, TCS,


What is node in db2?

0 Answers  


How does DB2 store NULL physically?

2 Answers  


Categories