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


Please Help Members By Posting Answers For Below Questions

Explain about rct.

646


What is a db2 schema?

760


Why do we use cursor?

597


What is blu acceleration in db2?

603


What is the max length of sqlca?

761






How to run db2 command in windows?

643


How to check last update on table in db2?

626


How connect db2 database to datastage?

761


How do you stop a db2 database in linux?

566


How to resolve deadlock issue

17969


How can you classify the locks in db2?

632


What is lock escalation in db2?

574


What is ibm db2 connect?

570


What is view db2?

622


What is query_cache_limit?

541