What is difference between rollback and commit?
- 1 Answers
- 1242 Views
- I also Faced
- E-Mail Answers
Answer / Anil Singh Dariyal
Commit saves all changes to the database permanently. Rollback discards all changes made since the last commit or savepoint.
| Is This Answer Correct ? | 0 Yes | 0 No |
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is the purpose of the QUIESE Utility?
How to handle null values in db2
In a DB2-CICS program which is acts as co-ordinator and which is participant?
What is the syntax for FETCH in DB2 ?
How Plan is created while executing the query using SPUFI?
What can the SET option of the Repair Utility accomplish?
what is different three logs in DB2?
What information is held in SYSIBM.SYSCOPY?
What is meant by explain?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What is cascading rollback?
COBOL 
