Difference between revisions of "SYSACTIVEUSERS"

From Recital Documentation Wiki
Jump to: navigation, search
Line 11: Line 11:
  
 
==See Also==
 
==See Also==
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SYSTEM TABLES]]
+
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]]
  
  

Revision as of 15:55, 13 March 2009

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