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
- 7182 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
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Who uses db2?
Why do chiropractors use drop table?
What is database manager in db2?
What are packages in db2?
Define declaration generator (dclgen).
What is runstats and reorg in db2?
Can you use max on a char column?
What is iseries database?
What is cloudant database?
What is null value in db2?
What is the function of logging in the db2 database?
What is reorg?
Explain db2.
What is the connection string to connect to the DB2 Database ?
