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 / krishna
Since declare cursor is not a executable statement hence it
might be declared in WSS.I am not sure...
| Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
What is the physical storage length of date data type?
What is the role of data manager in the db2 database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is meant by dclgen?
How to fetch the last row from the table in SQL (db2)?
How and when does the db2 enforces the unique key?
Name the lockable units in DB2?
Is ibm db2 open source?
List down the data types in the db2 database.
What is bind package and plan in db2?
What is database manager in db2?
What is meant by union and union all?
Where do you specify them?
What are the various data types available in db2?
Mention the different locking levels that are available in db2.