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
- 6243 Views
- UST, I also Faced
- E-Mail Answers
Answer / 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 |
How do you run JCL in cobol program
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
How to resolve -805 error in DB2?
How can you quickly find out the number of rows updated after an update statement?
What is db2 and what is the use of db2 optimizer?
what is plan? is plan executable or package?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Explain transactions, commits and rollbacks in DB2.
How is the SUBSTR keyword used in sql?
What is deadlock in db2?
COBOL 
