Can we declare cursor in Procudere division or open the cursor in the Working s

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

Question Posted / srprev

1 Answers
7875 Views
Infosys, I also Faced
E-Mail Answers

Can we declare cursor in Procudere division or open the cursor in the Working storage section. ..

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

Post New Answer

More DB2 Interview Questions

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers

How do I import a csv file into db2?

0 Answers

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers MCN Solutions,

What is concurrency?

0 Answers

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers CTS, IBM,

What is dclgen in db2?

0 Answers

What is runstats and reorg in db2?