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

How many sub queries can you combine together ?

4 Answers   IBM,


What is Call attach facility? How does it work?

1 Answers   Syntel,


What is the maximum No of rows per page?

0 Answers   IBM,


What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  


What is cursor stability?

1 Answers  


What is a cursor?

2 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


what is datacom db?

2 Answers   CSC,


Which isolation level provides maximum concurrency?

0 Answers  


Why do we bind in db2?

0 Answers  


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Categories