What are types of indexes?

0 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

What is the role of union all and union

0 Answers  

---

What is a SELECT statement?

1 Answers  

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is the use of db2 optimizer?

0 Answers  

---

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

2 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---