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
Is ibm db2 free?
How is the value function used?
Why cursor is used in db2?
How can you find out the # of rows updated after an update statement?
What does a deadlock mean in DB2?
What is the use of db2 optimizer?
What are db2 tables?
What is the result of open cursor statement?
what is a corelated subquerry?
How do I change the column size in db2?
How do I delete a table in db2?
Can there be more than one cursor open for any program?
What is the use of runstats in db2?
How and when does the db2 enforces the unique key?
What are the contents of a dclmgen?