Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8014 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepak
Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.
Commit-is use to save the records in data base for ex, I
have hundred records I got an abend in 50th records I can
save upto 49 records, and solve the issue and continue from
50th records,
Roll Back- it do not save the records if any abend occurs
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is meant by explain?
Name the lockable units in DB2?
How to execute stored procedures?
How to view db2 table structure?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Define check constraint.
What is null in db2?
What do you mean by rollback?
What is a buffer in memory?
Define declaration generator (dclgen).
What are the different types of base tables?
What does sqlcabc has?
How to fetch the last row from the table in SQL (db2)?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
