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 the picture clause of the null indicator variable?
Is it possible using max on a char column?
What is runstats db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How would the varchar column remarks defined?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
How to connect to db2 database from windows command line?
How to retrieve rows from a db2 table in embedded sql?
What is a Cartesian product?
What's the maximum number of volumes that can be added to a STOGROUP?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is a clustered index?