Answer Posted / bala
If the query inside the program retrieves only one row, there is no need to CURSOR.
If the program has to process the multiple rows that are retrieved by the query,
CURSOR is needed. Because, host variables can accommodate data from only one row at a time. By Declaring the cursor, multiple rows can be fetched one at a time and assign it to host variables for processing.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How do I create a view in db2?
What are the uses of db2 optimizer?
What is node in db2?
What is db2 bind process?
Explain package in db2 and its advantages?
If I have a view which is a join of two or more tables, can this view be updateable?
What are packages in db2?
How do I add a column in db2?
What is db2 and what is the use of db2 optimizer?
What is db2 command?
What is collection in db2 bind?
What is reorg?
What is the role of schema in the db2 database?
What is db2 bind?
What is the physical storage length of timestamp data type?
