Interested to Buy Any Domain ? << Click Here >> for more details...
when does the SQL statement gets executed when you use
cursor in the application programming ?
- 3 Answers
- 10532 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / m4io
It depends
If the cursor needs materialization then it gets executed
on "open cursor" like answer 1 and 2 say.
else
the query for the next row gets executed on each fetch.
Materialization happens f.e. when sorts are used.
You can close a cursor without having sqlcode +100.
Suppose a cics transaction reads a table (1.000.000 rows)
via an index : if only 20 rows are needed it will only
request 20 rows (1 each fetch) and then close the cursor.
In batch : if I get 100 pens and need to distribute them to
the people who requested some in order of date-requested, I
will close cursor as soon as 100 pens are distributed.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Give a brief description of db2 isolation levels?
What is the usage of open cursor command?
What is an instance database?
define clustering index.
What is copy pending and check pending in db2?
What is bind in db2?
Explain various types of locks in db2?
Name the lockable units in DB2?
What is cursor with hold option in db2?
What is isolation level in db2?
Explain in brief how does db2 determine what lock-size to use?
What is iseries database?
What are the bind parameters ibm db2?
What is scrollable cursor in db2?
What is schema in db2?
