<< CURRENT_TIMESTAMP | FB 2.1 Language Reference | CURRENT_USER >>
<< CURRENT_TIMESTAMP | FB 2.0 Language Reference | CURRENT_USER >>

CURRENT_TRANSACTION

Available in: DSQL, PSQL

Added in: 1.5

Description

CURRENT_TRANSACTION contains the unique identifier of the current transaction.

Type: INTEGER

Examples

 select current_transaction from rdb$database

 New.Txn_ID = current_transaction;

The value of CURRENT_TRANSACTION is stored on the database header page and reset upon restore. Unlike CURRENT_CONNECTION, it is incremented with every new transaction, whether the client reads the value or not.

See also:
CURRENT_CONNECTION
CURRENT_USER
CURRENT_ROLE

back to top of page
<< CURRENT_TIMESTAMP | FB 2.1 Language Reference | CURRENT_USER >>
<< CURRENT_TIMESTAMP | FB 2.0 Language Reference | CURRENT_USER >>