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



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

Answer / madhavi chava

As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.

we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.

Is This Answer Correct ?    18 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  


What is a synonym ?

2 Answers  


what are the SQL codes u freequently got?

2 Answers   Logica CMG,






How many buffer pools are available in db2?

2 Answers  


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,


What is reorg and runstats in db2?

0 Answers  


What is correlation names?

1 Answers  


What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  


Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,


Categories