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


Please Help Members By Posting Answers For Below Questions

can all users have the privilage to use the sql statement select * (dml)?

638


What is the role of schema in the db2 database?

649


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.

2322


Mention the definition of cobol in varchar field.

686


What is a system catalog table in db2?

586






On which levels locks can be applied?

655


What is host variable?

593


What is cloudant database?

641


Explain how can you do the explain of a dynamic sql statement?

649


How do you select a row using indexes in db2?

643


What is dbrm in db2 database?

586


How do I connect my db2 database to ibm?

600


What is buffer pool in the db2 database?

614


what are bind concepts in db2 cobol?

649


What do you mean by storage group (stogroup)?

581