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 / 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
|Is This Answer Correct ?||20 Yes||2 No|
What is ibm db2 database?
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?
If I have a view which is a join of two or more tables, can this view be updateable?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
Define declaration generator (dclgen).
What is a clustered index?
What is schema in db2?
What is index in db2?
Mention and explain the contention situations caused by locks?
When the like statement is used?
What is check constraint in db2?
Which catalog table stores referential constraints?