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
- 9239 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 |
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
List some fields from sqlca?
How can you count the number of rows from a table tab?
How to solve S0C7 abend with out using DISPlay in 10 mins?
why we go for SPUFI for creating tables or for sql queries?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Explain package in db2 and its advantages?
What does an outer join do?
Are views updatable ?
how to take the back up of the DB2 table.
What is index cardinality?
COBOL 
