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 is blu acceleration in db2?
How connect db2 database to datastage?
What are packages in db2?
Why do we bind in db2?
What are the uses of db2 optimizer?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is universal database?
What is the difference between bind and rebind in db2?
What is schema in db2?
What does db2 mean?
B37 abend during spufi?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to retrieve rows from a db2 table in embedded sql?
What is performance tuning db2?
What is meant by explain?
