As per my knowledge if we loop the select query it retrieves the same data

Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?

Question Posted / hitendra valluri

1 Answers
5965 Views
UST, I also Faced
E-Mail Answers

Answer Posted / hitendra valluri

As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is db2 a database?

911

How to test SQL -911 error while developing COB-DB2 program

7441

Name the lockable units in DB2?

1073

What are the benefits of using the db2 database?

1154

How do you eliminate duplicate values in db2?

1108

What is db2 purescale?

943

When reorg is used?

1071

What is dpf in db2?

1048

Why do chiropractors use drop table?

1044

What is the use of db2 optimizer?

1036

How to resolve deadlock issue

19864

Are view updateable?

980

List down the types of triggers in the db2 database?

963

What is nvl in db2?

1039

Explain the benefits you can get from mainframe connect?

910