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
What is data manager?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is runstats utility in db2?
What is the use of dclgen in db2?
What is syscat in db2?
What is the use of value function?
What is the purpose of rollback and commit?
Where do you specify them?
What type of database is db2?
Is db2 a mainframe database?
Mention the downsides of page level lock.
List some fields from sqlca?
How many databases can be created inside an instance in db2 ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is isolation level in db2?