SAP Adaptive
Server Enterprise Transaction management statements
You use the following transaction management statements with
transaction objects to manage connections and transactions for Adaptive
Server Enterprise databases:
-
CONNECT
-
COMMIT
-
DISCONNECT
-
ROLLBACK
Transaction management statements in
triggers
You should not use transaction statements in triggers. A trigger is
a special kind of stored procedure that takes effect when you issue a
statement such as INSERT, DELETE, or UPDATE on a specified table or
column. Triggers can be used to enforce referential integrity.
For example, assume that a certain condition within a trigger is not
met and you want to execute a ROLLBACK. Instead of coding the ROLLBACK
directly in the trigger, you should use RAISERROR and test for that
particular return code in the DBMS-specific return code (SQLDBCode)
property within the referenced transaction object.
See also
SAP Adaptive Server
Enterprise Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK