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
- 9240 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
What is syscat in db2?
How can you find out the # of rows updated after an update statement?
What is node in db2?
What is copy pending and check pending in db2?
How do I copy a table in db2?
How can you classify the locks in db2?
What is a plan and package in db2?
What does reorg do in db2?
What is difference between rollback and commit?
What are the different types of base tables?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How can we read records for specific member in CL? AND rpg?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the meaning concurrency in the db2 database?
How do I create a view in db2?
