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 bind plan?
What are host variables in db2?
How can you do the explain of a dynamic sql statement?
Which component is responsible for db2 startup and shutdown?
How would you find out the total number of rows in a db2 table?
What is a bind card?
What is the latest version of ibm db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How connect db2 database to datastage?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is an instance database?
What is copy pending status in db2?
What is the use of value function?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
