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

Is db2 a database?

574


What is reorg and runstats in db2?

694


Where do you specify them?

681


What is buffer pool in the db2 database?

616


What do you mean by rollback?

572






File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2375


What is the maximum length of sqlca?

869


What do you mean by storage group (stogroup)?

583


What is difference between isnull and coalesce?

620


What is lock escalation in db2?

574


What is null indicator in cobol db2?

585


How many databases are there?

590


What is rct?

751


How will you return the number of records in table?

516


Is db2 a programming language?

606