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
What is dpf in db2?
Is ibm db2 free?
What is the use of predicate?
How to check table size in db2 sap?
How and when does the db2 enforces the unique key?
Outputs of explain are with matchcols = 0. What does this signify?
What is db2 stogroup?
What is the maximum No of rows per page?
What is explain plan in db2?
Which components manage deadlocks in db2?
How to view db2 table structure?
Which component is responsible for db2 startup and shutdown?
What is buffer pool in the db2 database?
What is ibm db2 connect?
What's The Percentage Free Space ?