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
Where do you specify them?
What is meant by dclgen?
Mention the different locking levels that are available in db2.
How to find primary key of a table in db2?
How and when does the db2 enforces the unique key?
How to check sequence on a table in db2?
What is plan in cobol db2?
How can record locking be achieved in those DB2 versions which do not support it?
How does db2 sample database connect?
How do I import data from excel to db2?
How is the value function used?
How do I delete a table in db2?
What is db2 and what is the use of db2 optimizer?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How to find schema of a table in db2?