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 1. 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 schema map 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.

Refer to ODBC API and scalar functions in the Progress DataDirect for ODBC Drivers Reference for additional information.