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
- 7408 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 |
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What are some characteristics of columns that benefit from indexes?
How will you delete duplicate records from a table?
What is a collection?
How does one remove entries from the SCT02 table?
What DB2 Catalog column tell you when an index needs table reorganized ?
i want to maintain uniqueness on pdf without make lf??????????
when does the SQL statement gets executed when you use cursor in the application programming ?
How to resolve -803 sql code in DB2?
How to get the ddl of a table in db2?
What are the abend codes occour in ur latest PROJECT in DB2
What is the maximum size of a char data type in db2?
COBOL 
