What is the logical entity between plan and Package?
- 5 Answers
- 7805 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 |
What does CURRENTDATA option in bind indicate
Why do chiropractors use drop table?
Can we declare DB2 HOST variable in COBOL COPY book?
How do you define a correlated name?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
How to execute stored procedure in db2 command editor?
how to resolve -811 error. give clear explination
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
What does the CHECK Utility do ?
select 100 records from million records ?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How to see the structure of db2 table??
COBOL 
