Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor?
- 2 Answers
- 6558 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 primary key & unique index ?
how to copy the host variables from ps file into cobol program other than include statement
how to get duplicate records from tables?write qurey for this?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
How do I start db2 in windows?
Can we update view in db2?
How connect db2 database to datastage?
What is IMAGECOPY ?
What is cobol db2?
What is the difference between spufi and qmf?
wht happens if we close cursor with cursor with hold option?
What is package versioning? Please give an example.
COBOL 
