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
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What does sqlcabc has?
What are foreign keys in db2?
Is the primary key a clustered index?
what is the responsibility of the construction superintendent
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How does coalesce work?
What is meant by explain?
What is null in db2?
Why db2 is called db2?
What is a collection in db2?
How do I delete a table in database?
What is db2 bind process?
What is access path in db2?
What is the syntax for FETCH in DB2 ?