I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed?
Answer Posted / purushotham
Obviously it will close all the cursors.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is difference between rollback and commit?
What are the full forms of spufi and dclgen and why are they used?
What is dbrm? When it will be created?
what are bind concepts in db2 cobol?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Define check constraint.
What is db2 stogroup?
How can we retrieve the total number of records in RPG & CLLE?
What is schema in db2?
What is host variable in db2 cobol?
List some fields from sqlca?
Where can you declare a cursor in a cobol-db2 program?
What is difference between isnull and coalesce?
What is collection in db2 bind?