Interested to Buy Any Domain ? << Click Here >> for more details...
what is plan?
is plan executable or package?
- 4 Answers
- 11636 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 |
What are types of indexes?
What r the comman abends in db2, jcl and cobol???????
What are the disadvantages of using VARCHAR?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is a cursor in programming?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
How is the SUBSTR keyword used in sql?
What is the max length of sqlca?
What is a result table?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is host variable in db2 cobol?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
COBOL 
