CONNECTEDUSERS 

Definition

The system table CONNECTEDUSERS contains all the database users who are logged on.

Structure

CONNECTEDUSERS

USERNAME	CHAR(32)	Name of the user
TERMID	CHAR(18)	Terminal ID
SESSION	FIXED(10)	Database session
CATALOG_CACHE_SIZE	FIXED(10)	Size of the cache for catalog information in this database session (in pages)

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

See also:

Evaluating System Tables, SESSIONS

Concepts of the Database System, Database Users