why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
Answer Posted / srinivas g
Bind is type of compiler for the SQL statement.
It reads the SQL Statements from the DBRM and produces a mechanism to access data as directed by the SQL statements being bound.
Also checks Syntax, check for correctness of table & column definitions against the catalog information & performs authorization validation.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How connect db2 database to datastage?
What is the difference between cursor stability and repeatable read isolation levels?
What is db2 catalog database?
What are the uses of db2 optimizer?
What is the default page size of buffer pools?
How can you find out the # of rows updated after an update statement?
What are types of indexes?
is it compulsory commitment control in journal?
How do I import a csv file into db2?
What is the maximum number of columns in a db2 table?
Mention the location where the output received from explain statement is stored.
What do you mean by commit and rollback?
Explain about rct in db2?
Can we delete records from view?
Which isolation level provides maximum concurrency?