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 the sqlcode -501
Describe major components of db2?
What is the function of logging in the db2 database?
How can we retrieve the total number of records in RPG & CLLE?
What is copy pending and check pending in db2?
What is nvl in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How to execute stored procedure in db2 command editor?
What is query_cache_limit?
What is a db2 collection?
What is the information associated with sysibm.syslinks table?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
i want to maintain uniqueness on pdf without make lf??????????
What is db2 connect?
What is a Foreign Key?