Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
Answers were Sorted based on User's Feedback
No. In cobol-db2 program, the result of single select should be only one row.
For multi row fetch we must use cursor, else program will abend with -811 sql code.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / satheesh reddi
no...for that we are using cursors. due to cursors we can retrieve or fetch number of rows at a time from the table
| Is This Answer Correct ? | 0 Yes | 0 No |
How to rename a table in DB2 ?
What are some SQL aggregates and other built-in functions?
What does CURRENTDATA option in bind indicate
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is correlation names?
What is a dbrm in db2?
Explain packages.
How can we retrieve the total number of records in RPG & CLLE?
What is QUIESCE?
How do I create a view in db2?
What is the physical storage length of the data types date, time, and timestamp?
Return code 100 means?