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
What is rebind in db2?
What is package in db2 mainframe?
How can record locking be achieved in those DB2 versions which do not support it?
Explain correlated sub-queries.
Is db2 relational database?
What is copy pending and check pending in db2?
what is utility for parm lib
What is the maximum number of columns in a db2 table?
Explain how can you do the explain of a dynamic sql statement?
What is a system catalog table in db2?
What parameters are used to control the free space in DB2?
How to rename a table in DB2 ?
What is declare cursor?
What language is db2 written in?
Can we insert update delete in view?