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 are db2 objects?
How to find the maximum value in a column in the db2 database?
What is db2 look?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a system catalog table in db2?
What is dbrm in db2 database?
Highlight all the advantages that are attached to a package.
What is precompiler in db2?
What is schema in db2?
What does db2 plan contain?
What is the difference between bind and rebind in db2?
What is the maximum size of varchar data type in db2?
What is load replace in db2?
What is a db2 package?
What is innodb buffer pool?