Explain transactions, commits and rollbacks in DB2.
Answer Posted / kumar
Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.
Commit: Make the changes permanently in database
Rollback: Get back the changes to the database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is host variable?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Define db2.
How do I import data from excel to db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Is schema the same as database?
How do I copy a table in db2?
What is netezza database?
What is db2 bind process?
Is db2 relational database?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can we read records for specific member in CL? AND rpg?
What is bind and rebind in db2?
Which component is responsible for db2 startup and shutdown?
How to find primary key of a table in db2?