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 |
Suppose if I need to update a column, how you do that using cursor?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
how can u retrieve the data from null values using applicaion program.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What are the three types of page locks that can be held?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is sqlca?
What are the abend codes occour in ur latest PROJECT in DB2
what is a trigger and types of triggers
How can we retrieve the total number of records in RPG & CLLE?
What are column-name qualifiers used?
can you use symbolic parameters in JOB?