Context Variables

Unless explicitly mentioned otherwise in an “Available in” section, context variables are available in at least DSQL and PSQL.Availability in ESQL is — bar some exceptions — not tracked by this Language Reference.

`CURRENT_CONNECTION`

Unique identifier of the current connection.

Type

BIGINT

Syntax

CURRENT_CONNECTION

Its value is derived from a counter on the database header page, which is incremented for each new connection.When a database is restored, this counter is reset to zero.

Examples

select current_connection from rdb$database

execute procedure P_Login(current_connection)