Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor?
- 2 Answers
- 6652 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 the difference between Where and Having Clause
What is meant by union and union all?
What is schema in db2?
My SQL is not performing well. Describe how will you fine tune it?
How to find the number of rows in db2 tables?
Q4. How will you get the count of record without using COUNT verb in query?
What is check constraint in db2?
How to create a table using embedded sql?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is copy book?
what is the difference between where clause and having clause
How many clustering indexes can be defined for a table?
COBOL 
