Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of cursors?
- 3 Answers
- 7441 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 ibm db2 used for?
What is temporal table in db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
List some fields from sqlca?
What is a plan and package in db2?
What is dclgen (declaration generator)?
How to rename a table in DB2 ?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What are data types?
What is copy pending and check pending in db2?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is catalog database in db2?
COBOL 
