Answer Posted / 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 |
Post New Answer View All Answers
What is db2? Explain.
How can you find out the # of rows updated after an update statement?
What is copy pending and check pending in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
what is the role of the cursor in db2?
What language is db2 written in?
How to find schema of a table in db2?
List out the data types available.
How many databases can be created inside an instance in db2 ?
What os does db2 run on?
What do you mean by rollback?
What is node in db2?
How is the value function used?
What is a buffer in memory?
What are host variables in db2?