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

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  


What is db2 plan table?

0 Answers  


What does the RUNSTATS Utility do?

4 Answers  


Explain correlated sub-queries.

0 Answers  


What does db2 stand for?

0 Answers  


I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


What is SPUFI?

4 Answers  


What is release/acquire in bind?

0 Answers  


how can u understand the end of the table ?

1 Answers   TCS,


What is the difference between bind and rebind in db2?

0 Answers  


Is schema the same as database?

0 Answers  


what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,


Categories