What is the difference between a package and a plan?

Answer Posted / rajyalakshmi

Plan will contain the package we can execute the plan but
we cant execute the package.
Plan will contain number of packagees.In Package only one
DBRM is present but in plan number of DBRMs r there.

Is This Answer Correct ?    24 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is isolation level in db2?

577


How to check last update on table in db2?

628


What is buffer pool and list some of them?

630


What is the role of schema in the db2 database?

653


What is table space in db2?

584






What is the picture clause of null indicator variable?

693


Which component is used to execute the sql statements?

624


What is the physical storage length of date data type?

732


List down the data types in the db2 database.

637


My sql statement select avg(salary) from emp yields inaccurate results. Why?

643


What is host variable?

597


What does db2 stand for?

598


How do I copy a table in db2?

575


Explain package in db2 and its advantages?

598


Is db2 a mainframe database?

569