how to fetch multiple records without using cursor
Answer Posted / sivakumar sekharannair
None of the host languages can handle multiple records at a
time.
But i think if we know the number of rows that will be
retreived then we can load the records into a internal
table and then process it as required...
Any thoughts!!!!!!
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is meant by dclgen?
How does a cursor work?
Why cursor is used in db2?
What are bind parameters in db2?
What is dbrm? When it will be created?
Which isolation level provides highest data integrity?
Why do we bind in db2?
Why select is not preferred in embedded sql programs?
what is the responsibility of the construction superintendent
What is the difference between drop table and delete table?
How to test SQL -911 error while developing COB-DB2 program
Explain about cursor stability?
What are types of indexes?
What is collection in db2 bind?
What is release/acquire in bind?