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 / 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 |
What is netezza database?
what is db2 restart?
How many sub queries can you combine together ?
What is multi row fetch in db2?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Explain the benefits you can get from mainframe connect?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is Call attach facility? How does it work?
What is cursor?
What is page size in db2?
What is lock contention?
What's the maximum number of volumes that can be added to a STOGROUP?