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
- 6859 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 |
Which component is used to execute the sql statements?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
what are the bind parameters?
What is read-only cursor?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
How will you return the number of records in table?
What is an asychronous write?
How to know the primary key of a table without defining the primary key in the table?
What language is db2 written in?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is referential integrity?
COBOL 
