Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
- 1 Answers
- 6047 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
i want to maintain uniqueness on pdf without make lf??????????
What is dbrm? When it will be created?
How to find the maximum value in a column in the db2 database?
What do you mean by rollback?
What is the usage of open cursor command?
What's The Error Code For Unique Index Voilation?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Explain about mirror activator disk mirroring?
define clustering index.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is node in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is cloudant database?
What is the default page size of buffer pools?
What is deadlock in db2?
