Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor?
- 2 Answers
- 6561 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 |
what is a collection?
Mention the location where the output received from explain statement is stored.
How do you select a row using indexes in db2?
Discuss about db2 bind?
What is schema in db2?
What information is contained in a SYSCOPY entry?
how to check the table is empty or not?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
When do you specify the isolation level? How?
Are view updateable?
What is a view? Why use it?
What are the 4 environments which can access DB2 ?
COBOL 
