what is plan?
is plan executable or package?
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 |
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
How do you pull up a query which was previously saved in qmf?
What is the difference between cursor stability and repeatable read isolation levels?
What is meant by union and union all?
Can we declare DB2 HOST variable in COBOL COPY book?
How can you compare table column after update and before update?
how to resolve -818 error. how to see timestamp token in load module and plan
How can you do the explain of a dynamic sql statement?
What is a buffer pool?
why we create view.
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Why do chiropractors use drop table?