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.

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.

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

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

Is db2 a programming language?

0 Answers  

---

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

What is an access path?

3 Answers  

---

What is copy book?

1 Answers   Thomson Reuters,

---

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

---

When would you prefer to use VARCHAR?

3 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

What is a result table?

1 Answers  

---

What is db2 instance?

0 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---