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


Please Help Members By Posting Answers For Below Questions

What is the use of dclgen in db2?

589


What are packages in db2?

597


Can we update view in db2?

562


What is the difference between dbm cfg and db cfg file in db2 ?

1007


Name the lockable units in DB2?

665






What are the uses of db2 optimizer?

818


How can you do the explain of a dynamic sql statement?

637


What is a system catalog table in db2?

589


Explain the contents that are a part of dclgen.

661


How is a typical db2 batch pgm executed?

642


How many databases are there?

592


What is precompiler in db2?

587


What is runstats utility in db2?

569


What is a bind card?

681


List down the data types in the db2 database.

636