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
- 9648 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
Define check constraint.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the maximum No of rows per page?
How to find schema of a table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain the benefits you can get from mainframe connect?
What is the maximum size of varchar data type in db2?
List some fields from sqlca?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is temporal table in db2?
What is the difference between db2 and oracle?
What is db2 bind process?
What are the different types of base tables?
What is dbrm? What it contains? When it will be created?
