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 a db2 collection?
Explain the function of data manager.
What is bind plan?
can we view the access paths created by dbrm ? how ? thx
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is check constraint in db2?
How to access db2 tables in mainframe?
On which levels locks can be applied?
How do we specify index to include or not during bind process.
What is ibm db2 used for?
What is the information associated with sysibm.syslinks table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How many types of page locks can be held in db2?
What is the connection string to connect to the DB2 Database ?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected