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
- 9433 Views
- I also Faced
- E-Mail Answers
Answer Posted / srisri
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
When the like statement is used?
How to find primary key of a table in db2?
Explain correlated sub-queries.
How to rename a table in DB2 ?
What is the max length of sqlca?
Mention the location where the output received from explain statement is stored.
Define predicate?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How can you count the number of rows from a table tab?
What is the purpose of using commit?
Highlight all the advantages that are attached to a package.
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.
What are the benefits of using the db2 database?
What is difference between isnull and coalesce?
What are the prerogatives?
