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 / 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 |
What is usage pointer in cobol?
What is the difference between group by and order by?
How do I add a column to a table in db2?
What is a db2 package?
When will you chose to run RUNSTATS?
How would the varchar column remarks defined?
What is meant by dclgen?
how can u understand the end of the table ?
How to insert more than one record using insert?
What is the role of data manager in the db2 database?
Define db2 and its databases?
How many buffer pools are available in db2?