Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
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 |
What does db2 plan contain?
What is copy pending status in db2?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Explain in detail about buffer manager and its functionalities?
What is db2 optimizer?
How to resolve -502 sql code in DB2?
What is db2 and what is the use of db2 optimizer?
i want to maintain uniqueness on pdf without make lf??????????
What is a view? Why use it?
wht steps we need will coding cobol and db2 pgm ?
What is a Cartesian product?
What action db2 takes when a program aborts in the middle of a transaction?