Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes?
- 4 Answers
- 7224 Views
- I also Faced
- E-Mail Answers
Answer Posted / sankar
All changes happens to database are initially made in log,
after successful completion of unit of work (COMMIT),the
changes from log reflected into physical database. In case
of roll-back or un-successful completion, changes will not
be reflested into physical database.
Commit executed at the end of all transaction (explicitly
or inplicitly) irrespective of number of rows affected.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is db2? Explain.
What is ibm db2 connect?
Is db2 a mainframe?
What is syscat in db2?
Mention some fields that are a part of sqlca.
How to find the number of rows in db2 tables?
How to create db2 table in mainframe?
What is sqlca?
What does db2 stand for?
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 contents of dclgen?
What is a plan and package in db2?
What kind of database is db2?
define clustering index.
Mention the various locks that are available in db2.
