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 is copy pending status in db2?

0 Answers  


What is CHECK PENDING ?

5 Answers  


What do you mean by rollback?

0 Answers  


What is phantom read in db2?

0 Answers  


what are stage one indexable predicates?

1 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


Can you Average the Characters ?

3 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


When is the skeleton cursor table created?

1 Answers  


How is a typical DB2 batch program executed ?

1 Answers  


What is a base table?

2 Answers  


How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,


Categories