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
- 9480 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridhar
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 37 Yes | 0 No |
Answer / srisri
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is multi row fetch in db2?
What is database alias db2?
What is IMAGECOPY ?
Write a query to retrive partial string.
How many types of page locks can be held in db2?
What is copy pending status in db2?
What is a precompiler?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is release/acquire in bind?
How to know the primary key of a table without defining the primary key in the table?
How would the varchar column remarks defined?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
COBOL 
