what is plan?
is plan executable or package?
- 4 Answers
- 9734 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 |
How to create db2 table in mainframe?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
what is the role of the cursor in db2?
What is a synonym ?
What is the difference between db2 and oracle?
Is the primary key a clustered index?
What is db2 connect?
What is a base table?
Give a brief description of db2 isolation levels?
How to execute stored procedures?
what is the difference between declaring the cursor in WS section and Procedure division?
COBOL 
