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
How do I start db2 in windows?
What is db2 and what is the use of db2 optimizer?
What are the prerogatives?
What is the picture clause of null indicator variable?
What is rct?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is phantom read in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Why do we need reorg in db2?
What is the use of runstats in db2?
How do I connect my db2 database to ibm?
can all users have the privilage to use the sql statement select * (dml)?
Can you use max on a char column?
Explain correlated sub-queries.
What is dbrm?