Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4659 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 db2 restart?
Explain the benefits you can get from mainframe connect?
How to find the number of rows in db2 tables?
Can we delete records from view?
What is the maximum size of varchar data type in db2?
Name the lockable units in DB2?
What is the maximum length of sqlca?
What is phantom read in db2?
What is schema in db2?
What does db2 mean?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is reorg?
Where do you specify them?
What is package in cobol db2?
How can record locking be achieved in those DB2 versions which do not support it?
