Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
- 2 Answers
- 3983 Views
- L&T, UST, I also Faced
- E-Mail Answers
Answer Posted / azharuddinsyed
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 |
Post New Answer View All Answers
What is a storage group (stogroup)?
Is db2 a mainframe?
What do you mean by cursor?
Explain the benefits you can get from mainframe connect?
Can one database have multiple instances?
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 bind process?
Which isolation level provides maximum concurrency?
what is utility for parm lib
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Mention data types used in db2 ?
What is db2 look?
Explain db2.
Mention the different locking levels that are available in db2.
