Rolls back a user's transaction
Scope of validity
DBH and SESDCN administration
Function
The ROLLBACK-TRANSACTION statement rolls back the transaction of a specific user.
A user's transaction can only be rolled back if it is open.
Resources requested outside the scope of transaction are not released.
You cannot use this statement to roll back PTC transactions. You require the ROLLBACK-PTC-TRANSACTION administration statement to do that.
It is not possible with the ROLLBACK-TRANSACTION statement to roll back transactions that have the status UTI (see "SHOW-TRANSACTIONS"), since these transactions are really only statements. These statements are only displayed with SHOW-TRANSACTIONS because they can hold locks. To cancel such statements, use CANCEL-STATEMENT (see "CANCEL-STATEMENT").
The ROLLBACK-TRANSACTION administration statement is rejected if the DBH was loaded without transaction management.
The statement is also rejected if the user addressed has opened a lock sequence.
ROLLBACK-TRANSACTION |
USER = <user-identification> |
Operands
USER = <user-identification>
Identifies the user whose transaction is to be rolled back. The identification must be unique. You must specify all the relevant partial qualifications (see section “Syntax for the identification of users”). In SESDCN administration, you must enter names for APPLICATION-NAME and CUSTOMER-NAME in the *BY-SELECT(...) operand for <user-identification>. An entry for HOST-NAME is optional. If you select the default (*NONE) for HOST-NAME, SESAM/SQL uses the name of the computer on which the SESDCN to be administered is running.
Administration command in ISP format and at the CALL DML interface
The RESET administration command corresponds to the ROLLBACK-TRANSACTION administration statement here.
RESET,user-identification