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
- 10624 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
What is rebind in db2?
What is a plan and package in db2?
What is commit in db2?
What is the use of predicate?
What do you mean by rollback?
How many types of page locks can be held in db2?
What is the role of union all and union
What is db2 and what is the use of db2 optimizer?
What is view db2?
How do you select a row using indexes in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is database reorganization?
What is multi row fetch in db2?
What is the default page size of buffer pools?
Which command is used to remove all rows from a table?
