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.
TIA
Answer Posted / ns
There is no difference. But it is always better to declare
Cursor in Working-Storage Section because you will not code
Open Cursor before Declare Cursor by mistake. It is just a
standard to declare Cursor in WSS. As best practice to
avoid oversight.
Is This Answer Correct ? | 28 Yes | 6 No |
Post New Answer View All Answers
How can you find out the # of rows updated after an update statement?
What do you mean by rollback?
Comment whether the cursor is closed during commit or not.
what is the responsibility of the construction superintendent
What is runstats and reorg in db2?
What is role in db2?
List out the three types of page locks that can be held.
What's The Error Code For Unique Index Voilation?
What is copy pending and check pending in db2?
Why do we bind in db2?
What is cobol db2?
define clustering index.
What are the different types of base tables?
What are the full forms of spufi and dclgen and why are they used?
Why do we use cursor?