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


Please Help Members By Posting Answers For Below Questions

What is a db2 collection?

593


Explain the function of data manager.

617


What is bind plan?

592


can we view the access paths created by dbrm ? how ? thx

6195


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

677






What is check constraint in db2?

581


How to access db2 tables in mainframe?

588


On which levels locks can be applied?

635


How do we specify index to include or not during bind process.

1657


What is ibm db2 used for?

576


What is the information associated with sysibm.syslinks table?

631


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

561


How many types of page locks can be held in db2?

574


What is the connection string to connect to the DB2 Database ?

594


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10633