Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor?
- 2 Answers
- 6544 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 do you need to do before you do EXPLAIN ?
Mention the downsides of page level lock.
What techniques will be used to avoid deadlock??
what's the best lock size that you could use when you create a tablespace?
how can u retrieve the data from null values using applicaion program.
What are the various isolation levels possible?
Can any one tell me about Restart logic in DB2.
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is copy book?
What is IMAGECOPY ?
How many clustering indexes can be defined for a table?
What is Skeleton cursor table (SKCT)?
COBOL 
