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
- 7248 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 buffer pool?
What is db2? Explain.
How do I add a column in db2?
Is db2 free?
Can you use max on a char column?
How do I delete a column in db2?
What is the physical storage length of timestamp data type?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Define declaration generator (dclgen).
What is cobol db2?
Who uses db2?
What language is db2 written in?
What are union and union all?
How many databases are there?
What is iseries database?
