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

What is check constraint in db2?

835


What is consistency token in db2?

878


What is null indicator in db2?

863


What is the use of dclgen in db2?

811


What is the physical storage length of timestamp data type?

865


Is the primary key a clustered index?

849


How do we specify index to include or not during bind process.

1873


Why select is not preferred in embedded sql programs?

960


What is runstats utility in db2?

771


Name the lockable units in DB2?

912


What happens in bind step in a db2 program?

745


What is coalesce in db2?

879


What is package in cobol db2?

883


What is access path in db2?

747


How many types of page locks can be held in db2?

829