Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of cursors?
- 3 Answers
- 7372 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 do you mean by NOT NULL? When will you use it?
What is runstats db2?
What is the use of predicate?
What is runstats and reorg in db2?
Can SQL statements/queries be included in a copybook?
How to execute stored procedure in db2 command editor?
What is alias in db2?
what is consistency token
How do I delete a table in database?
what is utility for parm lib
What are concurrency issues?
How do I import data from excel to db2?
COBOL 
