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
8858 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

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers CTS,

What are the prerogatives?

0 Answers

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

how do we solve soc 7 and soc4 ?

3 Answers Tech Mahindra,

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers

what is the use of commit ? and what is the syntax?

2 Answers Deloitte,

How Plan is created while executing the query using SPUFI?