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 the use of dclgen in db2?
What are packages in db2?
Can we update view in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
Name the lockable units in DB2?
What are the uses of db2 optimizer?
How can you do the explain of a dynamic sql statement?
What is a system catalog table in db2?
Explain the contents that are a part of dclgen.
How is a typical db2 batch pgm executed?
How many databases are there?
What is precompiler in db2?
What is runstats utility in db2?
What is a bind card?
List down the data types in the db2 database.