Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of cursors?
- 3 Answers
- 7436 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
Cursors are used for providing multiple rows to process in
host language by fetching one row at a time.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / siri
it is use to retrive more than one row for an sql query return in application program....with out using cursors then it abbends with an sql code -811...
| Is This Answer Correct ? | 2 Yes | 0 No |
What is consistency token in db2?
What is db2 look?
Why do we bind in db2?
What is sqlca?
What else is there in the PLAN apart from the access path?
What is a host variable?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How does one remove entries from the SCT02 table?
What is DCLGEN ?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
COBOL 
