It can be done with the help of dynamic sql queries (prepare,execute). bu

how to fetch multiple records without using cursor

Question Posted / premil

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

Please Help Members By Posting Answers For Below Questions

What is schema in db2?

959

What is the role of union all and union

1066

What does db2 stand for?

956

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

1017

What is runstats utility in db2?

961

List down the data types in the db2 database.

1038

Why do chiropractors use drop table?

1044

How do I start db2 in windows?

1018

what is diffrence b/w file-aid tool and file-aid utility???

4807

How to test SQL -911 error while developing COB-DB2 program

7436

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

987

Is ibm db2 free?

948

What is dclgen in db2?

1078

Which component is responsible for processing sql statements and selecting access paths?

1069

How to rename a table in DB2 ?

1023