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 view db2?
How to create db2 table in mainframe?
Who uses db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Which component is responsible for processing sql statements and selecting access paths?
What are packages in db2?
What is cursor in dbms?
Why do chiropractors use drop table?
What is a trigger in the db2 database?
What is the use of db2 optimizer?
What is a db2 cursor?
How do I connect my db2 database to ibm?
What action db2 takes when a program aborts in the middle of a transaction?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to access db2 tables in mainframe?