what is the use of cursors?
- 3 Answers
- 6281 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 the use of predicate?
What is the error code -803 ?
Explain various types of locks in db2?
What is lock escalation?
What are packages in db2?
what is plan? is plan executable or package?
Explain about mirror activator disk mirroring?
B37 abend during spufi?
What is the difference between spufi and qmf?
i have a db2 variable how do u declare tht into working storage section ?
What does an outer join do?
What is index cardinality?
COBOL 
