Chapter 15 System Tables
1033
SYSREMOTEUSER system table
Column name Column type
Column
constraint
Table constraints
user_id UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSUSERPERM
consolidate CHAR(1) NOT NULL
type_id UNSIGNED INT NOT NULL Foreign key references
SYSREMOTETYPE
address LONG,
VARCHAR
NOT NULL
frequency CHAR(1) NOT NULL Unique index
send_time TIME Unique index
log_send NUMERIC(20,0) NOT NULL
time_sent TIMESTAMP
log_sent NUMERIC(20,0) NOT NULL
confirm_sent NUMERIC(20,0) NOT NULL
send_count INTEGER NOT NULL
resend_count INTEGER NOT NULL
time_received TIMESTAMP
log_received NUMERIC(20,0) NOT NULL
confirm_received NUMERIC(20,0)
receive_count INTEGER NOT NULL
rereceive_count INTEGER NOT NULL
Each row describes a userid with REMOTE permissions (a subscriber),
together with the status of SQL Remote messages that were sent to and from
that user.
user_id The user number of the user with REMOTE permissions.
consolidate (Y/N) Indicates whether the user was granted
CONSOLIDATE permissions (Y) or REMOTE permissions (N).
type_id Identifies which of the of the message systems supported by SQL
Remote is used to send messages to this user.
To Next Page
Loading...