Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


sa_transactions system procedure

Returns a list of transactions that are currently active.

sa_transactions( )
Result set
Column name Data type Description
connection_num INT The connection ID for the connection the transaction is running on.
transaction _id INT The ID that uniquely identifies the transaction as long as the database server keeps track of it. IDs are reused as old transaction information is discarded.
start_time TIMESTAMP The TIMESTAMP for when the transaction started.
start_sequence_num UNSIGNED BIGINT The start sequence number for the transaction.
end_sequence_num UNSIGNED BIGINT Then end sequence number for the transaction if it has been committed or rolled back, otherwise, NULL.
committed bit The state of the transaction: true if the transaction ended with a COMMIT, false if it ended with a ROLLBACK, and NULL if the transaction is still active.
version_entries unsigned INT The count of the number of row versions the transaction has saved.

This procedure provides information about the transactions that are currently running against the database.


DBA authority required

Side effects


See also