Can we declare cursor in Procudere division or open the
cursor in the Working storage section.
Is there any particular rules in the usage of cursors lifecycle
Answer Posted / omkar panda
yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor
Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
What is clone table?
Where do you specify them?
What is a buffer in memory?
What is the use of with ur in db2?
What db2 400?
What is a trigger in the db2 database?
Comment whether the cursor is closed during commit or not.
What are bind parameters in db2?
What is runstats and reorg in db2?
How do I add a column in db2?
What is the difference between spufi and qmf?
What is the meaning concurrency in the db2 database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How do we specify index to include or not during bind process.
What parameters are used to control the free space in DB2?