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 to find schema of a table in db2?
What is phantom read in db2?
What is node in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is an instance database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is an instance in db2?
What are the contents of dclgen?
What is explain plan in db2?
When do you specify the isolation level?
What do you mean by rollback?
How to retrieve rows from a db2 table in embedded sql?
What is reorg and runstats in db2?
What is database reorganization?
What is a bind in db2?