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

How do I optimize a query in db2?

1091

On which levels locks can be applied?

1117

What is dbrm? What it contains? When it will be created?

1043

What is cloudant database?

1088

Which components manage deadlocks in db2?

1058

How to execute stored procedures?

1120

What are the contents of a dclmgen?

1115

Why do we need reorg in db2?

978

How to restart a DB2 program?

1883

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

1096

How can you count the number of rows from a table tab?

1083

How will you return the number of records in table?

924

What are the uses of db2 optimizer?

1286

Explain about rct.

1080

What is check constraint in db2?

1070