Contents Index SYSREMOTETYPE system table SYSSCHEDULE system table

ASA SQL Reference
  System Tables

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 SMALLINT 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.

address    The address to which SQL Remote messages are to be sent. The address must be appropriate for the address_type.

frequency        How frequently SQL Remote messages are sent.

send_time        The next time messages are to be sent to this user.

log_send    Messages are sent only to subscribers for whom log_send is greater than log_sent.

time_sent    The time the most recent message was sent to this subscriber.

log_sent    The log offset for the most recently sent operation.

confirm_sent    The log offset for the most recently confirmed operation from this subscriber.

send_count        How many SQL Remote messages have been sent.

resend_count    Counter to ensure that messages are applied only once at the subscriber database.

time_received    The time when the most recent message was received from this subscriber.

log_received    The log offset in the subscriber's database for the operation that was most recently received at the current database.

confirm_received    The log offset in the subscriber's database for the most recent operation for which a confirmation message has been sent.

receive_count        How many messages have been received.

rereceive_count    Counter to ensure that messages are applied only once at the current database.


Contents Index SYSREMOTETYPE system table SYSSCHEDULE system table