Interested to Buy Any Domain ? << Click Here >> for more details...
What is the logical entity between plan and Package?
- 5 Answers
- 8750 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kamal
plan is an optimized access path,but it is an executable component,package contains optimized access path,which is generated by optimizer of bind & it is a non-executable component.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sridhar reddy
When ever a main progran is executed it is going to create
a DBRM for example if the main program calls n sub programs
then these n sub program need N DBRM's A total of N+1 DBRMs
are needed. A Plan is required to run These DBRM's .
Instead of placing all these DBRM's in a plan , for each
DBRM one package is created & these packages inturn call a
plan.
Instead of placing DBRM's in a plan a package is created
because if we modify any thing no need recompile all the
DBRM's
posted by Sridhar BhumiReddy
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / vamsi
Plan is an executabel one which provides access path to
access the DBRM's.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / praveen
plan contains address of package.
package contains data set.
| Is This Answer Correct ? | 0 Yes | 1 No |
Can you use max on a char column?
What is a dbrm in db2?
What is the result of open cursor statement?
Can you Average the Characters ?
What is PRIME TABLE and what are the uses of it
what's the best lock size that you could use when you create a tablespace?
What is deadlock?
What type of database is db2?
Q3. How will you fetch duplicate values from a DB2 table?
Mention and explain the contention situations caused by locks?
how can we find nth max salary from A table
Name some fields from SQLCA
COBOL 
