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 the role of union all and union
How do I connect my db2 database to ibm?
What parameters are used to control the free space in DB2?
When the like statement is used?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is meant by dclgen?
What are the rules for db2 programming?
What is the difference between bind and rebind in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is a trigger in the db2 database?
How does db2 sample database connect?
Why select is not preferred in embedded sql programs?
List down the data types in the db2 database.
What is reorg?
What is the latest version of ibm db2?