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

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

what are the bind parameters?

5 Answers   IBM,

---

Mention some fields that are a part of sqlca.

0 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

Explain the function done by data manager?

0 Answers  

---

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---

What is isolation level in db2?

0 Answers  

---