Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
Answer Posted / mehdee
. Plans are created by BIND command on sysibm.sysplan. To
execute a package, you must 1st include it in the package
list of a PLAN, so they are only executed when the plan in
which they are contained executes.
PACKAGEs are related to a PLAN, and PLANs are related to
a COLLECTION-ID. So when we REBIND a Package we do not need
to BIND REPLACE the Plan.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is null value in db2?
What is the use of dclgen in db2?
What is dbrm? What it contains?
Why select is not preferred in embedded sql programs?
What do you mean by between and in? Is between inclusive of specified range values?
Give the name of some fields form sqlca.
What is the use of commit in db2?
What is the difference between db2 and oracle?
What is a cursor in programming?
What is sqlca?
What does db2 plan contain?
What is the use of with ur in db2?
What is a db2 schema?