Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
- 1 Answers
- 6081 Views
- UST, I also Faced
- E-Mail Answers
Answer / hitendra valluri
As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
What is the result of open cursor statement?
How to define the a field which accepts value till 99999.99 in db2
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is referential integrity?
What is the clustering index in the db2 database?
What is a system catalog table in db2?
What is the logical entity between plan and Package?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is explain plan in db2?
What are the abend codes occour in ur latest PROJECT in DB2
What is the difference between cursor and select statement?
COBOL 
