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
can all users have the privilage to use the sql statement select * (dml)?
What is the role of schema in the db2 database?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Mention the definition of cobol in varchar field.
What is a system catalog table in db2?
On which levels locks can be applied?
What is host variable?
What is cloudant database?
Explain how can you do the explain of a dynamic sql statement?
How do you select a row using indexes in db2?
What is dbrm in db2 database?
How do I connect my db2 database to ibm?
What is buffer pool in the db2 database?
what are bind concepts in db2 cobol?
What do you mean by storage group (stogroup)?