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
- 9300 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 the use of COMMAREA ?Minimum how much data we can pass from it?
Give the name of some fields form sqlca.
wht steps we need will coding cobol and db2 pgm ?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How can you quickly find out the number of rows updated after an update statement?
How to access db2 tables in mainframe?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is the logical entity between plan and Package?
What does DSNDB07 database do?
COBOL 
