Answer / s

Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.

Answer / harsha

cursor is used to retrive multiple rows.

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

What are db2 tables?

0 Answers  

---

What is access path in 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  

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is meant by isolation level?

3 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

Can we update view in db2?

0 Answers  

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---