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 do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

What is DCLGEN ?

2 Answers  

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---

How can the duplicate values be eliminated from db2 select?

0 Answers  

---

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---

What is a Database Request Module(DBRM)?

4 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

What is the usage of open cursor command?

0 Answers  

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

Is the primary key a clustered index?

0 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---