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 the responsibility of the construction superintendent
Explain about rct.
How does a cursor work?
What is explain in db2?
What is difference between isnull and coalesce?
What are catalog tables in db2?
What is the role of schema in the db2 database?
What is the meaning concurrency in the db2 database?
What is cursor in dbms?
How and when does the db2 enforces the unique key?
Why select is not preferred in embedded sql programs?
what is the sqlcode -501
What is iseries database?
What is the syntax for FETCH in DB2 ?
How to run db2 command in windows?