Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor?
- 2 Answers
- 6471 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
A cursor is a programming device that is used to handle the
rows that are returned by the query as the host language
(cobol) can handle only one row at a time. its also a small
file that has the result set. The cursor has to be
declared,opened, fetched and closed to access the data
returnee by the query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vinod babu bachina
In DB2 cursor is used to fetch more than one row from a DB2
table. But cursor can fetch only one row at a time. Suppose
if ur retrieving more than one row from table , u have to
use cursor only. If u use SELECT instead of cursor then it
leads to error '' more than one row selected in select'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain transactions, commits and rollbacks in DB2.
Explain in detail about buffer manager and its functionalities?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What is db2 instance?
What are the various locks available?
What is the size of a data page?
what is SMP/E? and what are the major steps of it? thanks...
What is a bind card?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What are the contents of a dclmgen?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is a cursor?
COBOL 
