skip to main content
Querying data stores with SQL : Catalog tables : SYSTEM_SESSIONS catalog table
  

Try Now

SYSTEM_SESSIONS catalog table

The system table named SYSTEM_SESSIONS stores information about current system sessions. The values in the SYSTEM_SESSIONS table are read-only.
The following table defines the columns of the SYSTEM_SESSIONS table.
Table 204. SYSTEM_SESSIONS
Column
Data type
Description
SESSION_ID
INTEGER, NOT NULL
A unique ID that identifies this session. The system function CURSESSIONID( ) returns the session ID associated with the connection.
CONNECTED
DATETIME, NOT NULL
The date and time the session was established.
USER_NAME
VARCHAR (128), NOT NULL
The name of the embedded database that the session is using.
IS_ADMIN
BOOLEAN
For internal use only.
AUTOCOMMIT
BOOLEAN, NOT NULL
For future use.
READONLY
BOOLEAN, NOT NULL
True if the connection is in read-only mode. The READONLY status is based on whether the connection has been explicitly set to read-only mode by the Read Only connection option.
MAXROWS
INTEGER, NOT NULL
For future use.
LAST_IDENTITY
BIGINT, NULLABLE
For future use.
TRANSACTION_SIZE
INTEGER, NOT NULL
For future use.
CURRENT_SCHEMA
VARCHAR (128), NOT NULL
The current schema for the session. The current schema may be changed using the ALTER SESSION SET CURRENT_SCHEMA statement.
STMT_CALL_LIMIT
INTEGER, NOT NULL
The maximum number of Web service calls that the driver uses in attempting to execute a query to a remote data source. The statement call limit for the session may be changed via the ALTER SESSION SET STMT_CALL_LIMIT statement.