SYSACTIVEUSERS

From Recital Documentation Wiki
Revision as of 15:53, 13 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SYSACTIVEUSERS

Class

SQL Applications


Purpose

Description of currently active users on the system


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
ACTIVE N 1 True if Active, False if exited uncleanly
GID C 8 Group ID
UID N 8 User ID
PID C 8 Process ID
USER_NAME C 25 User name
TERMINAL N 25 Terminal name
CLIENT C 25 Client connection
DATE D 4 Login date
TIME C 8 Login time


Example

EXEC SQL
SELECT user_name
FROM sysactiveusers;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer