Answer Posted / 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 can we read records for specific member in CL? AND rpg?

644

---

What does db2 blu stand for?

1101

---

How does cobol compile db2 program?

1006

---

Explain how can you do the explain of a dynamic sql statement?

1063

---

Are views updateable?

1070

---

What is the difference between nvl and coalesce?

1009

---

What is coalesce in db2?

1055

---

Is db2 a programming language?

983

---

How does a cursor work?

929

---

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

969

---

What is bind in db2?

976

---

What is rebind in db2?

999

---

What is a plan and package in db2?

1043

---

What is deadlock in db2?

1017

---

What is copy pending and check pending in db2?

950

---