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 cloudant database?
What is difference between rollback and commit?
How to get the ddl of a table in db2?
What is a trigger in the db2 database?
Before you give the explain statement, what are the prerogatives?
Define buffer pool.
What is the use of reorg in db2?
What is an instance database?
What is dbrm?
Is db2 a programming language?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How do I add a column to an existing table in db2?
What is the difference between bind and rebind in db2?
define clustering index.
Which command is used to remove all rows from a table?
