how to fetch multiple records without using cursor

Answer Posted / premil

It can be done with the help of dynamic sql queries
(prepare,execute).
but i dont remember the syntax...
sorry ...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is universal database?

607


What is page size in db2?

559


What is the picture clause of null indicator variable?

680


Explain in brief how does db2 determine what lock-size to use?

586


Is db2 free?

673






How to retrieve rows from a db2 table in embedded sql?

712


What is a db2 table?

587


How does a cursor work?

551


How do I create a view in db2?

594


What is the clustering index in the db2 database?

572


define clustering index.

612


On which levels locks can be applied?

649


What is runstats utility in db2?

557


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

646


What is the cobol picture clause of the db2 data types date, time, timestamp?

601