The system table CONNECTPARAMETERS contains information about session-specific parameters.
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