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 database manager in db2?

541


Explain how can you do the explain of a dynamic sql statement?

643


What is cloudant database?

636


What is the function of logging in the db2 database?

635


What action db2 takes when a program aborts in the middle of a transaction?

646






What is consistency token in db2?

626


Where do you specify them?

672


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

619


What is db2?

732


What is rct?

741


Which are the db2 tools to protect integrity of the database?

678


Which command is used to remove all rows from a table?

543


What is a cursor in programming?

583


How connect db2 database to datastage?

751


What is ibm db2 client?

512