skip to main content
Catalog tables : SYSTEM_SESSIONS catalog table
 

Try DataDirect Cloud 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 64. 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. For more information on CURSESSIONID(), refer to Supported SQL and Extensions.
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 connectivity service 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.