What else is there in the PLAN apart from the access path?
Answer / s
The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.
| Is This Answer Correct ? | 3 Yes | 0 No |
How do I add a column to a table in db2?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
is it compulsory commitment control in journal?
What is dbrm?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What are the Isolation levels possible ?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is runstats and reorg in db2?
Define sqlca.
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the STOSPACE Utility used for?
When would you prefer to use VARCHAR?