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
What is clone table?
can all users have the privilage to use the sql statement select * (dml)?
What is db2 purescale?
What is difference between alias and synonym in db2?
What does a deadlock mean in DB2?
What is database alias db2?
What happens in bind step in a db2 program?
What is rct?
What is the use of db2?
Define db2 and its databases?
What is the max length of sqlca?
What is dclgen in db2?
What is a collection in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Define predicate?