CURRENT_TRANSACTION

<< CURRENT_TIMESTAMP | FB 2.5 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. It is incremented with every new transaction.

See also:
CURRENT_CONNECTION
CURRENT_USER
CURRENT_ROLE

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