what is plan?
is plan executable or package?
- 4 Answers
- 10156 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
paln is nothing but collection of packages
paln is executable where package is non-executable
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / tej
A small correction for Harsha's answer
Plan can also contain DBRMs along with collections of packages.
and Yes,Plan is executable where as package is not.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / nidhi
Plan and packages both are executable.
Package is the executable form of single DBRM while
multiple pacages or DBRM can be bind together through the
same plan.
| Is This Answer Correct ? | 2 Yes | 10 No |
Answer / hatam
A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not
| Is This Answer Correct ? | 0 Yes | 19 No |
When is the access path determined for dynamic SQL?
What should be specified along with a cursor in order to continue updating process after commit?
What is a thread?
What is the significance of DB2 free space and what parameters control it?
What is a bind in db2?
B37 abend during spufi?
What is index cardinality?
If I have a view which is a join of two or more tables, can this view be updateable?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is ibm db2 database?
Highlight all the advantages that are attached to a package.
What is a clustering index ?
COBOL 
