Interested to Buy Any Domain ? << Click Here >> for more details...
5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued?
- 2 Answers
- 6139 Views
- I also Faced
- E-Mail Answers
Answer Posted / rashmi
The 5 inserted records will not be there in the table.
Becouse rollback is happening before the commit(Untill
unless you commit it, the changes will not reflect in the
table).
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is a cursor in programming?
Can one database have multiple instances?
How to test SQL -911 error while developing COB-DB2 program
Explain package in db2 and its advantages?
What action db2 takes when a program aborts in the middle of a transaction?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
can all users have the privilage to use the sql statement select * (dml)?
What is the difference between spufi and qmf?
What is ibm db2 used for?
What is host variable in db2 cobol?
Are views updateable?
What is dbrm library?
What is the difference between dbm cfg and db cfg file in db2 ?
Explain the benefits you can get from mainframe connect?
Is db2 a mainframe database?
