what is the difference between declaring the cursor in WS
section and Procedure division?
Answer / 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 |
What is a lock?
What are the three DB2 date and time data types and their associated functions?
What is innodb buffer pool?
What is a DB2 catalog?
How do you Load a table ?? and what is Load replace ?
Update command
What is the max length of sqlca?
What is coalesce in db2?
Before you give the explain statement, what are the prerogatives?
How can you compare table column after update and before update?
What is the difference between spufi and qmf?
What is ACQUIRE/RELEASE in BIND?