Answer / yuvaevergreen

>>Cursors are memory structures used to handle multiple
rows at a time.
>>Though,select statement can fetch only multiple rows, we
cannot handle multiple rows using host variables.
Basic difference would be single row handling and multiple
rows handling.

Answer / reddy

cursors are used to retrieve multiple rows . Cussors will
retrieve one row at a time and save the data in the
hostvariables.For retreiving the 2 nd row, we need to
repeat the loop.the same process is continued at the end of
data.

select stmt will retrieve multiple rows at a time. assume
that there are 10 rows in a table.
EX: EXEC SQL
SELECT empno , ename into :hvempno ,:hvename from emp;
END EXEC;

Here the above sql query reults all the 10 rows. But , the
host variables will hold only one row of data.the remaining
9 rows will not be stored any where.

hope this may help u

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

What is a buffer in memory?

0 Answers  

---

What is read-only cursor?

1 Answers  

---

What is db2 stogroup?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

What is lock escalation?

2 Answers  

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is the logical entity between plan and Package?

5 Answers  

---

When do you specify the isolation level? How?

1 Answers  

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

What is isolation level in db2?

0 Answers  

---