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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_table_stats system procedure Next Page

sa_transactions system procedure

Returns a list of transactions that are currently active.


sa_transactions( )

Result set
Column name Data typeDescription
connection_numINTThe connection ID for the connection the transaction is running on.
transaction _idINTThe 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_timeTIMESTAMPThe TIMESTAMP for when the transaction started.
start_sequence_numUNSIGNED BIGINTThe start sequence number for the transaction.
end_sequence_numUNSIGNED BIGINTThen end sequence number for the transaction if it has been committed or rolled back, otherwise, NULL.
committedbitThe 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_entriesunsigned INTThe 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