Interested to Buy Any Domain ? << Click Here >> for more details...
can any body explain about plan and pakage in detail....
- 2 Answers
- 9900 Views
- HSBC, IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivasa gudla
A package is single bound DBRM with optimized access paths.
It contains location identifier, collection Identifier and
package identifier.
A package can have multiple versions, each with it's own
version identifier
Advantages of Packages,
Reduce the Bind Time.
Versioning.
Can provide BIND options at programmer level.
As Ashish mentioned above, Plan contains packages list which
is nothing but Pointers. whenever you are doing changes in
SQL staetments related to particular DBRM . Then only that
particular Packages needs to be rebind not the Plan. This is
similar to recompiling a sub program not the main program.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the meaning concurrency in the db2 database?
What is clone table?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is difference between alias and synonym in db2?
How to find primary key of a table in db2?
Who uses db2?
What is meant by explain?
What is difference between isnull and coalesce?
What is db2 purescale?
What db2 400?
Mention some fields that are a part of sqlca.
what is the sqlcode -501
Can you use max on a char column?
