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

2 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

What is QUIESCE?

2 Answers  

---

Explain about open switch business continuity software?

0 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

How to create a table using embedded sql?

1 Answers  

---