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

2 Answers
4660 Views
L&T, UST, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

1090

What is plan in cobol db2?

1129

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

1099

What is the syntax for seeing the columns and data types of a table in the db2 database?

1161

Explain package in db2 and its advantages?

1201

How can you classify the locks in db2?

1085

Which isolation level provides maximum concurrency?

1150

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3198

Explain db2.

1022

How do I change the column size in db2?

1151

What is difference between alias and synonym in db2?

1131

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9181

Explain how can you do the explain of a dynamic sql statement?

1117

B37 abend during spufi?

1450

What is db2 catalog database?

1033