Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 9435 Views
- I also Faced
- E-Mail Answers
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
Can there be more than one cursor open for any program?
Define declaration generator (dclgen).
What is db2 bind process?
What is database manager in db2?
Explain what are the various isolation levels possible?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What r the comman abends in db2, jcl and cobol???????
can we view the access paths created by dbrm ? how ? thx
How will you return the number of records in table?
What is page size in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How do you eliminate duplicate values in db2?
List out the buffer pools in db2
What is the reason behind not using select * in embedded sql programs?
Mention data types used in db2 ?
