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



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

What are the three DB2 date and time data types and their associated functions?

1 Answers  


how to fetch first 100 rows in db2

2 Answers   IBM,


What are db2 tables?

0 Answers  


How do you check for a null value in a db2 column?

2 Answers  


How do you retrieve the data from a nullable column?

2 Answers  






What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,


What is the purpose of the QUIESE Utility?

1 Answers  


Name some fields from SQLCA.

2 Answers  


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


Can you use max on a char column?

0 Answers  


What does reorg do in db2?

0 Answers  


what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,


Categories