Answer / guest

A cursor is a programming device that is used to handle the
rows that are returned by the query as the host language
(cobol) can handle only one row at a time. its also a small
file that has the result set. The cursor has to be
declared,opened, fetched and closed to access the data
returnee by the query.

Answer / 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'.

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

What is innodb buffer pool?

0 Answers  

---

what is consistency token

3 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

What is nvl in db2?

0 Answers  

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

how to take the back up of the DB2 table.

7 Answers  

---

How will you return the number of records in table?

0 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---