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 happens to the PLAN if index used by it is dropped?
what is cursor stability?
What techniques are used to retrieve data from more than one table in a single SQL statement?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What will happen, while trying to close the closed cursor.
How to define the a field which accepts value till 99999.99 in db2
What is Call attach facility? How does it work?
i want to maintain uniqueness on pdf without make lf??????????
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
How many sub queries can you combine together ?
Is schema the same as database?