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. See "Functions" for more information about the CURSESSIONID() system function.
|
CONNECTED
|
DATETIME, NOT NULL
|
The date and time the session was established.
|
USERNAME
|
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 ReadOnly connection option or the Connection.setReadOnly() method.
|
MAX_ROWS
|
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.
|