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  

---

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 join and union?

4 Answers   IBM,

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

What is cursor?

2 Answers  

---

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

0 Answers   MCN Solutions,

---

When is the access path determined for dynamic SQL?

2 Answers  

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

What is a clustering index ?

3 Answers  

---

What will the COMMIT accomplish?

5 Answers  

---