Interested to Buy Any Domain ? << Click Here >> for more details...
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT
IS THE USE OF PACKAGE?
- 2 Answers
- 16235 Views
- Tech Mahindra, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
See there is not doubt that PLAN is an executable form of
DBRM and package is not the executable form.
Basically a DBRM can be linked to PLAN directly or a DBRM
can be linked to Package and that package can further linked
to the PLAN
Now if we directly link the DBRM with the plan then every
time we recompile the program(DBRM) we have to regenerate
the plan.
Whereas if we link the DBRM via package then every time we
recompile the program(DBRM) we only require to recompile the
Package.
Hence Binding through package prevents regeneration of plan.
1 more line I want to add just for knowledge.
If we regenerate the PLAN every time then all the other
Programs(DBRMs) which are attached to that same PLAN
required to be rebind thus take waste time.
Hope this answers your query...
| Is This Answer Correct ? | 27 Yes | 2 No |
What r the comman abends in db2, jcl and cobol???????
How many buffer pools are available in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is deadlock?
can all users have the privilage to use the sql statement select * (dml)?
Mention the downsides of page level lock.
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
Who uses db2?
How can you get the number of rows impacted by the last executed query?
What is a Resource Control Table(RCT)? Describe its characteristics.
how can we find nth max salary from A table
COBOL 
