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 a dbrm in db2?
Is db2 a database?
What are host variables in db2?
How will you return the number of records in table?
Why cursor is used in db2?
How to get the ddl of a table in db2?
What is db2 bind process?
Before you give the explain statement, what are the prerogatives?
How would the varchar column remarks defined?
Are views updateable?
Explain the benefits you can get from mainframe connect?
Explain in brief how does db2 determine what lock-size to use?
What is difference between alias and synonym in db2?
Discuss about db2 bind?
Is db2 free?