Yes its possible in NATURAL using MULTI-FETCH Option.

how to fetch multiple records without using cursor

Question Posted / chakradhar patra

Answer Posted / chakradhar patra

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the clustering index in the db2 database?

956

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

What is dclgen in db2?

1082

What's The Percentage Free Space ?

1157

Explain in detail about buffer manager and its functionalities?

993

What is schema in db2?

962

What do you mean by commit and rollback?

974

What is db2? Explain.

987

What does reorg do in db2?

984

How to compare data between two tables in db2?

1032

What is drop table?

959

What are concurrency issues?

1029

How to check last update on table in db2?

1001

What are the prerogatives?

1014

Which component is used to execute the sql statements?

1053