Difference between revisions of "SET ROLLBACK"

From Recital Documentation Wiki
Jump to: navigation, search
(Example)
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=SET ROLLBACK=
 
 
 
==Class==
 
Multi-User
 
 
 
 
==Purpose==
 
==Purpose==
 
Enable or disable automatic rollback
 
Enable or disable automatic rollback
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[BEGIN TRANSACTION]], [[END TRANSACTION]], [[RESET IN]], [[ROLLBACK]], [[COMPLETED()]], [[ISMARKED()]], [[ROLLBACK()]]
+
[[BEGIN TRANSACTION]], [[COMPLETED()]], [[END TRANSACTION]], [[ISMARKED()]], [[RESET IN]], [[ROLLBACK]], [[ROLLBACK()]]
  
  
Line 28: Line 21:
 
use setcomm
 
use setcomm
 
set rollback on
 
set rollback on
 +
 
begin transaction
 
begin transaction
 
     delete first 15
 
     delete first 15
Line 33: Line 27:
 
     list
 
     list
 
end transaction
 
end transaction
 +
 
if completed()    && determine if the transaction was successful
 
if completed()    && determine if the transaction was successful
 
     dialog box "Transaction completed"
 
     dialog box "Transaction completed"
 
else
 
else
 
     dialog box "Errors occurred during transaction"
 
     dialog box "Errors occurred during transaction"
endif</code>
+
endif
 +
</code>
 +
 
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|ROLLBACK]]
 
[[Category:Set_Commands|ROLLBACK]]
 +
[[Category:Transaction Processing]]
 +
[[Category:Transaction Processing Set Commands]]

Latest revision as of 15:30, 25 November 2009

Purpose

Enable or disable automatic rollback


Syntax

SET ROLLBACK ON | OFF | (<expL>)


See Also

BEGIN TRANSACTION, COMPLETED(), END TRANSACTION, ISMARKED(), RESET IN, ROLLBACK, ROLLBACK()


Description

The SET ROLLBACK ON command invokes automatic rollback and recovery in all tables affected by transactions performed within a BEGIN TRANSACTION....END TRANSACTION block. A ’rollback’ causes record contents to be restored to their value before modification (e.g. at the time BEGIN TRANSACTION was issued). This is particularly useful if an error occurs during the execution of a program or if an Applications Data Dictionary validation constraint is not satisfied.

When BEGIN TRANSACTION is issued all currently open files and all files opened between BEGIN and END TRANSACTION will have Before Image Journaling invoked automatically. To disable rollback for a particular workarea, see the RESET IN command. Recital Corporation recommends the use of the SET ROLLBACK ON command to obtain automatic rollback and recovery on multi-statement transactions. By default, ROLLBACK is OFF.


Example

use setcomm
set rollback on
 
begin transaction
    delete first 15
    replace all t1 with (t2*t3)/100
    list
end transaction
 
if completed()    && determine if the transaction was successful
    dialog box "Transaction completed"
else
    dialog box "Errors occurred during transaction"
endif


Products

Recital Server, Recital