why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
Answer Posted / sk
during compilation of a DB2 program. The host language (eg
COBOL) code and SQL code will be separated.
The SQL codes will be processed and optimised access path
will be generated; the path forms the plan.
The host code will be compiled with its own host compiler
and the executable code will be generated.
The BIND step binds both the executable codes of SQL and
host language; the outcome is the final executable code.
Without bind a DB2 program will not execute.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is difference between alias and synonym in db2?
What is the purpose of rollback and commit?
Describe major components of db2?
How do you find the maximum value in a column in db2?
What is the role of the data page in the db2 database?
What is dclgen (declaration generator)?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is node in db2?
What are concurrency issues?
What is the difference between db2 and oracle?
what is a corelated subquerry?
What's The Percentage Free Space ?
What are the bind parameters ibm db2?
What is cloudant database?
What is the difference between bind and rebind in db2?