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 |
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
What is cursor stability?
How do I add a column to an existing table in db2?
What can the Locate option of the Repair Utility accomplish?
What is db2 purescale?
Explain correlated sub-queries.
What is the difference between drop table and delete table?
what are the SQL codes u freequently got?
Are view updateable?
What is the reason behind not using select * in embedded sql programs?
What is query_cache_limit?