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
Why select is not preferred in embedded sql programs?
When reorg is used?
What is the maximum No of rows per page?
What is schema in db2?
How does db2 sample database connect?
How to retrieve rows from a db2 table in embedded sql?
How would you find out the total number of rows in a db2 table?
What is temporal table in db2?
What is difference between rollback and commit?
How do I delete a table in db2?
How do I delete a table in database?
What is the maximum length of sqlca?
What is db2 optimizer?
How many databases are there?
What do you mean by cursor?