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 |
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What does the REORG Utility do?
What will happen, while trying to close the closed cursor.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Can we declare DB2 HOST variable in COBOL COPY book?
What is scrollable cursor in db2?
how to fetch multiple records without using cursor
What is bind package and plan in db2?
What is the difference between primary key & unique index ?
Which catalog tables contain authorization information?
What is the difference between spufi and qmf?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?