6. QUEL and EQUEL Statements : Abort Statement--Undo an MQT : Examples
 
Share this page                  
Examples
The following examples provide details.
Example 1:
The following examples show the use of abort to undo all the updates performed by the transaction.
## begin transaction
## append to emp(empname="jones,bill", 
##   sal=100000, bdate=1814)
## append to emp(empname="jones,bill", sal=100000,
##   bdate=1714)
## abort  /* undoes both appends; table is unchanged */
Example 2:
The following example shows the use of savepoints to undo the updates performed between savepoints "setone" and "settwo."
## begin transaction
## append to emp(empname="jones,bill", sal=10000,
##   bdate=1945)
## savepoint 1
## append to emp(empname="smith,stan", sal=50000,
##   bdate=1911)
## savepoint settwo 
## abort to 1
## /*undoes 2nd append, deactivates savepoint settwo */
## append to emp(empname="smith,stan", sal=50000,
##   bdate=1948)
## abort to 1
## end transaction   
/* only the first append is committed */