Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
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
Highlight all the advantages that are attached to a package.
What is the clustering index in the db2 database?
What is the difference between oracle and db2?
What is the maximum size of a char data type in db2?
What is drop table?
What is the difference between bind and rebind in db2?
Explain the benefits you can get from mainframe connect?
Which are the db2 tools to protect integrity of the database?
What are the two types of logging in the db2 database? Explain them.
Explain about dbrm.
What is a system catalog table in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What db2 400?
How do I import a csv file into db2?
What is meant by explain?