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 / r.l.v.krishna
COMMIT WILL CLOSE ALL THE CURSORS IF U R NOT MENTIONED WITH HOLD OPTION IN THE DECLARATION PART OF THE CURSOR....
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 used for?
List out the three types of page locks that can be held.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is database reorganization?
How to retrieve rows from a db2 table in embedded sql?
Define data page.
What is difference between rollback and commit?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
List out the data types available.
What is the cobol picture clause of the db2 data types date, time, timestamp?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is universal database?
What is a Foreign Key?
What is meant by explain?