Interested to Buy Any Domain ? << Click Here >> for more details...
what is plan?
is plan executable or package?
- 4 Answers
- 11406 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 |
Is it possible using max on a char column?
What is the role of union all and union
Which catalog tables contain authorization information?
What is the role of data manager in the db2 database?
What is a clustered index?
What is an alias and how does it differ from a synonym?
How to resolve -917 sql code in DB2?
How do I create a view in db2?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is database manager in db2?
Explain in detail about buffer manager and its functionalities?
Outputs of explain are with matchcols = 0. What does this signify?
COBOL 
