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 a DB2 access path?
What is rct?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
How to know the primary key of a table without defining the primary key in the table?
What is clone table?
Can a array declared with an index be displayed(readable format) in spool?
Explain packages.
What is table space in db2?
what is the name of the default db2 catalog database?
What are the 2 sqlcodes that are returned?
wt is view ? wht r the restrictions for view ?
What is the physical storage length of timestamp data type?