Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are catalog tables in db2?
What is null value in db2?
What is schema in db2?
What is host variable?
How does db2 sample database connect?
What is a collection in db2?
What is page size in db2?
What is precompiler in db2?
What is db2 and what is the use of db2 optimizer?
What is meant by dclgen?
How do I add a column in db2?
What is the use of with ur in db2?
What is buffer pool in the db2 database?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What types of tables are there in the db2 database?
