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 rebind in db2?

809


What is package in db2 mainframe?

759


How can record locking be achieved in those DB2 versions which do not support it?

873


Explain correlated sub-queries.

805


Is db2 relational database?

780


What is copy pending and check pending in db2?

780


what is utility for parm lib

2138


What is the maximum number of columns in a db2 table?

1031


Explain how can you do the explain of a dynamic sql statement?

890


What is a system catalog table in db2?

879


What parameters are used to control the free space in DB2?

869


How to rename a table in DB2 ?

859


What is declare cursor?

864


What language is db2 written in?

821


Can we insert update delete in view?

783