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
- 4771 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 the cobol picture clause of the db2 data types date, time, timestamp?
What is concurrency?
Which component is responsible for db2 startup and shutdown?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is buffer pool and list some of them?
How to find primary key of a table in db2?
What is reorg?
What is bind plan?
How connect db2 database to datastage?
What is null in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is access path in db2?
What is the maximum size of varchar data type in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Define sqlca.
