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
- 7048 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
List out the data types available.
List down the types of triggers in the db2 database?
What is a system catalog table in db2?
what is db2 restart?
What is meant by dclgen?
What is db2 bind process?
What is precompiler in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is universal database?
What is package in cobol db2?
What is a bind card?
Why cursor is used in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How can record locking be achieved in those DB2 versions which do not support it?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
