Chapter 12. 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.

12.1. CURRENT_CONNECTION

Unique identifier of the current connection.

TypeBIGINT

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)