Interested to Buy Any Domain ? << Click Here >> for more details...
What are PACKAGES ?
- 3 Answers
- 9109 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul nittala
The concept of packages came from this particular problem
which was faced earlier:
when there were no packages, all the dbrms for a respective
program have to be bound directly to the plan. In such
cases, whenever there was any change made to any calling or
called program within the plan, all the modules had to be
bound to their individual dbrm and then all the dbrms had
to be bound to the plan. To avoid this, the concept of
package was introduced which was just an address location
in the memory and not a physical entity. By introducing the
package concept, it was not necessary to bind all the
individual dbrms again, only that module to which change
was done had to be bound to that respective package. There
will be a one - to - one relation between a dbrm and a
package. A package actually stores the address of the dbrm.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / s
Packages are single bound DBRM. When there is an change
made to the application pgm, it requires only the bind of
the package as opposed to binding the whole plan if the
DBRM was directly bound to the plan.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / deepak dada
packages is which contains the optimised path for
accessing the db2 packages cannt be executed by itself it
can be executed when is cotained in plan
| Is This Answer Correct ? | 2 Yes | 1 No |
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
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 do you need to do before you do EXPLAIN ?
What is reorg and runstats in db2?
If I have a view which is a join of two or more tables, can this view be updatable?
How can you do the explain of a dynamic sql statement?
What is catalog database in db2?
max number of columns in a db2 table?
Could anyone clearly explain the diference between sub query and correlated sub query?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
can you use symbolic parameters in JOB?
COBOL 
