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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11347


What does sqlcabc has?

775


What are foreign keys in db2?

809


Is the primary key a clustered index?

814


what is the responsibility of the construction superintendent

1858


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

838


How does coalesce work?

741


What is meant by explain?

827


What is null in db2?

740


Why db2 is called db2?

758


What is a collection in db2?

750


How do I delete a table in database?

764


What is db2 bind process?

910


What is access path in db2?

721


What is the syntax for FETCH in DB2 ?

871