no...for that we are using cursors. due to cursors we can retrieve or fetch

Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?

Question Posted / satheesh reddi

Answer Posted / satheesh reddi

no...for that we are using cursors. due to cursors we can retrieve or fetch number of rows at a time from the table

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is rebind in db2?

1072

What is universal database?

1074

What is buffer pool?

1110

Mention the location where the output received from explain statement is stored.

1129

Can one database have multiple instances?

1057

What is check constraint in db2?

1092

How would you find out the total number of rows in a db2 table?

1055

Explain the benefits you can get from mainframe connect?

974

Explain about dbrm.

1051

What is runstats and reorg in db2?

1307

How many databases are there?

1060

Define predicate?

1140

What is an instance database?

1057

What is a db2 table?

1022

How to create db2 table in mainframe?

1157