What is a cursor?
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 |
how to fetch first 100 rows in db2
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
Which command is used to remove all rows from a table?
how to copy the host variables from ps file into cobol program other than include statement
What are the contents of dclgen?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
How can you split a table in to exactly half?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
pls explain the precompilation process of cobol-db2 pgm
What is the difference between dbm cfg and db cfg file in db2 ?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
i want to delete 20th million record how ?