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

What is clone table?

592


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

643


What is db2 purescale?

551


What is difference between alias and synonym in db2?

645


What does a deadlock mean in DB2?

653






What is database alias db2?

611


What happens in bind step in a db2 program?

569


What is rct?

752


What is the use of db2?

587


Define db2 and its databases?

620


What is the max length of sqlca?

768


What is dclgen in db2?

678


What is a collection in db2?

584


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.

2757


Define predicate?

645