Interested to Buy Any Domain ? << Click Here >> for more details...
what is plan?
is plan executable or package?
- 4 Answers
- 11567 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 is null in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a LIKE table and how is it created?
What is an instance database?
How to create backup table in db2?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What is dbrm library?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is bind in db2?
What type of database is db2?
What is package in db2 mainframe?
What is Call attach facility? How does it work?
COBOL 
