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
Define declaration generator (dclgen).
What is difference between rollback and commit?
What does db2 blu stand for?
Which command is used to remove all rows from a table?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What do you mean by storage group (stogroup)?
How do I create a view in db2?
what is the role of the cursor in db2?
What is the reason behind not using select * in embedded sql programs?
can we view the access paths created by dbrm ? how ? thx
What is the difference between bind and rebind in db2?
What is the function of logging in the db2 database?
What are the contents of dclgen?
What is cursor with hold option in db2?
What is db2 optimizer?