what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What is db2 catalog database?

0 Answers  

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What is cursor in dbms?

0 Answers  

---

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

How do I import data from excel to db2?

0 Answers  

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

What is buffer pool in the db2 database?

0 Answers  

---

What is syscat in db2?

0 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  

---