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

What are the full forms of spufi and dclgen and why are they used?

0 Answers  


How to check last update on table in db2?

0 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


Explain what are the various isolation levels possible?

0 Answers  


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


What is the difference between plan and package in db2?

0 Answers  


in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


What is null in db2?

0 Answers  


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

2 Answers   Deloitte,


What is package in db2 mainframe?

0 Answers  


Categories