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
How can we retrieve the total number of records in RPG & CLLE?
What is ibm db2 client?
How to create db2 table in mainframe?
Why do we bind in db2?
What is the physical storage length of timestamp data type?
How to check table size in db2 sap?
How many types of page locks can be held in db2?
How can the duplicate values be eliminated from db2 select?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Explain about rct in db2?
How to restart a DB2 program?
Mention the location where the output received from explain statement is stored.
What is role in db2?
What is catalog database in db2?
How does a cursor work?