CONNECTPARAMETERS

Definition

The system table CONNECTPARAMETERS contains information about session-specific parameters.

Structure

CONNECTPARAMETERS

SQLMODE

CHAR(8)

SQL mode (ANSI | DB2 | ORACLE | INTERNAL)

ISOLEVEL

FIXED(10)

Isolation level (0-3)

TIMEOUT

FIXED(10)

Value for session timeout

SESSION

FIXED(10)

Database session

The system table CONNECTPARAMETERS exists only to enable compatibility with older database versions. Instead of the system table CONNECTPARAMETERS, use the system table SESSIONS.

See also:

Evaluating System Tables, SESSIONS