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
- 6889 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 utility for parm lib
What are the different types of base tables?
What is runstats and reorg in db2?
How to execute stored procedure in db2 command editor?
What are the bind parameters ibm db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a trigger in the db2 database?
What is a cursor in programming?
How to view db2 table structure?
What is db2 command?
What are catalog tables in db2?
How to run db2 command in windows?
What are db2 objects?
What is the advantage in De-normalizing tables in DB2?
If I have a view which is a join of two or more tables, can this view be updateable?
