Answer / s

Collection is a logical grouping of packages, eg grouping
by application, Grouping by environment like test,
production. It is not a physical object.

Answer / prasad

Hierarchy

Plan

Collection of collections is Plan

Collection

Collection of packages is Collection

Package

Collection of items is Package

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

What are the uses of db2 optimizer?

0 Answers  

---

can any one expalin check point with an example?

1 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?

0 Answers   HeadStrong,

---

what are stage one indexable predicates?

1 Answers  

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

what is the role of the cursor in db2?

0 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is meant by index cardinality?

2 Answers  

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---