Interested to Buy Any Domain ? << Click Here >> for more details...
Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
- 2 Answers
- 7168 Views
- IBM, I also Faced
- E-Mail Answers
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
What is package in db2 mainframe?
How does a cursor work?
What are catalog tables in db2?
Explain package in db2 and its advantages?
What is the use of dclgen in db2?
What is the maximum number of columns in a db2 table?
What is db2 catalog database?
How is deadlock resolved?
How can we read records for specific member in CL? AND rpg?
How can you quickly find out the # of rows updated after an update statement?
Why select is not preferred in embedded sql programs?
What is sqlca?
What is the difference between oracle and db2?
What is db2 command?
What do you mean by cursor?
