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 deadlock in db2?

585


What are the contents of a dclmgen?

628


What does runstats do in db2?

607


How do I import a csv file into db2?

562


What is the role of data manager in the db2 database?

649






What is a Foreign Key?

658


Explain about rct.

654


What is the clustering index in the db2 database?

585


How do I delete a table in database?

599


Explain the function done by data manager?

857


What is the difference between spufi and qmf?

639


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

1007


How does cobol compile db2 program?

610


How do you concatenate the firstname and lastname from emp table to give a complete name?

603


What is package in cobol db2?

704