Can we declare cursor in Procudere division or open the
cursor in the Working storage section.
Is there any particular rules in the usage of cursors lifecycle
Answer Posted / omkar panda
yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
How to view db2 table structure?
What is cascading rollback?
what is db2 restart?
Which isolation level provides maximum concurrency?
What are concurrency issues?
What is the default page size of buffer pools?
What is the maximum number of columns in a db2 table?
How and when does the db2 enforces the unique key?
How do I optimize a query in db2?
How do you select a row using indexes in db2?
What is db2 instance?
What is buffer pool?
What is dbrm?
What is the meaning concurrency in the db2 database?
What do you mean by storage group (stogroup)?