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
6165 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

What are concurrency issues?

1170

Which component is responsible for db2 startup and shutdown?

1079

What is node in db2?

1098

How does a cursor work?

1037

What is the use of reorg in db2?

1137

What is the physical storage length of date data type?

1304

What are the contents of a dclmgen?

1176

What is database manager in db2?

1061

What is load utility in db2?

1227

What is db2 stogroup?

1220

How to check last update on table in db2?

1097

Can you use max on a char column?

1139

What is bind plan?

1095

What are iseries servers?

1126

How to find the number of rows in a db2 table?

1154