When is the results table for the query in a DECLARE CURSOR
statement created?
Answer Posted / mehdee
It is not OPEN CURSOR is executed, it is the 1st FETCH.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
How can the duplicate values be eliminated from db2 select?
Which are the db2 tools to protect integrity of the database?
How is a typical db2 batch pgm executed?
Define sqlca.
What is the role of union all and union
What is the syntax for FETCH in DB2 ?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is cascading rollback?
What is reorg?
What is package in db2 mainframe?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the use of runstats in db2?
What is db2 and what is the use of db2 optimizer?