HP 3000 Manuals

ALLBASE/SQL Reference Manual

TERMINATE TRANSACTION 

The TERMINATE TRANSACTION statement terminates a given transaction.

Scope 

ISQL or Application Programs

SQL Syntax 

TERMINATE TRANSACTION FOR {CID ConnectionID }
                          {XID TransactionID}
Parameters 

CID ConnectionID        identifies the specific connection in which the
                        transaction to be terminated is running.

XID TransactionID       identifies a specific transaction to be
                        terminated.

Description 

   *   The transaction in progress for the connection is terminated and
       any changes are backed out.

Authorization 

You can terminate a transaction if it is your own transaction, or if you
have DBA authority.  Also the TERMINATE AT QUERY LEVEL or TERMINATE AT
TRANSACTION LEVEL option must have been set for the specified connection
or transaction.  See SET TRANSACTION or SET SESSION for more information
on these options.

Example 

      TERMINATE TRANSACTION FOR CID ConnectionID3 
[REV END]

MPE/iX 5.5 Documentation