Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
Answer Posted / 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 |
Post New Answer View All Answers
What is buffer pool and list some of them?
What is netezza database?
What is a plan and package in db2?
Explain the contention situations caused by locks?
How connect db2 database to datastage?
What are host variables in db2?
What is difference between alias and synonym in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to find the number of rows in a db2 table?
How do I change the column size in db2?
What is dpf in db2?
Explain various types of locks in db2?
What does sqlcabc has?
What is the use of commit in db2?
What are the various isolation levels possible?