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 |
Can a array declared with an index be displayed(readable format) in spool?
What is sqlca’s maximum length?
What are the various locks available?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to find the maximum value in a column in the db2 database?
what is SMP/E? and what are the major steps of it? thanks...
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
can i code union in cobol-db2 pgm ?
What is the function of buffer manager?
Plan has the optimized access path in it. But is that optimized access path is attained or known
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Which isolation level provides highest data integrity?