Answer Posted / vinod babu bachina

In DB2 cursor is used to fetch more than one row from a DB2
table. But cursor can fetch only one row at a time. Suppose
if ur retrieving more than one row from table , u have to
use cursor only. If u use SELECT instead of cursor then it
leads to error '' more than one row selected in select'.

What is sqlca?

1089

---

What is the use of runstats in db2?

1121

---

B37 abend during spufi?

1464

---

List out the data types available.

1163

---

Explain db2.

1045

---

Where do you specify them?

1296

---

Explain the function done by data manager?

1286

---

What is db2 command?

1045

---

Is ibm db2 free?

1022

---

How do I optimize a query in db2?

1106

---

What is alias in db2?

1070

---

What is ibm db2 client?

948

---

What are db2 objects?

1057

---

What is buffer pool in the db2 database?

1117

---

How to resolve deadlock issue

20167

---