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

Discuss about db2 bind?

1154

How to find the number of rows in db2 tables?

1127

Explain package in db2 and its advantages?

1270

Where do you specify them?

1366

What are catalog tables in db2?

1105

What is runstats db2?

1074

How would the varchar column remarks defined?

1127

What is null in db2?

1068

How to connect to db2 database from windows command line?

1134

B37 abend during spufi?

1509

What are iseries servers?

1131

How to find the maximum value in a column in the db2 database?

1125

What is load replace in db2?

1046

What is the maximum size of varchar data type in db2?

1175

What is the difference between db2 and oracle?

1176