Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 is ibm db2 database?

0 Answers  


can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  


If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


Define declaration generator (dclgen).

0 Answers  






What is a clustered index?

1 Answers  


What is schema in db2?

0 Answers  


What is index in db2?

1 Answers  


Mention and explain the contention situations caused by locks?

1 Answers  


When the like statement is used?

0 Answers  


What is check constraint in db2?

0 Answers  


Which catalog table stores referential constraints?

1 Answers  






Categories