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
- 6854 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhav
Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is plan in cobol db2?
How to view db2 table structure?
How do you select a row using indexes in db2?
What is the syntax required for the creation of a cursor?
What is the difference between dbm cfg and db cfg file in db2 ?
What are iseries servers?
What is the error code -803 ?
What is a precompiler?
pls tell me abt the normalization five types....
What is the difference between oracle and db2?
Can a array declared with an index be displayed(readable format) in spool?
COBOL 
