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
Explain about rct.
What is a db2 schema?
Why do we use cursor?
What is blu acceleration in db2?
What is the max length of sqlca?
How to run db2 command in windows?
How to check last update on table in db2?
How connect db2 database to datastage?
How do you stop a db2 database in linux?
How to resolve deadlock issue
How can you classify the locks in db2?
What is lock escalation in db2?
What is ibm db2 connect?
What is view db2?
What is query_cache_limit?