Sybase SQL Remote DC38133-01-0902-01 User Manual
Column
Description
publication_name
The name of the publication
creator
The owner of the publication
remarks
Comments
SYSREMOTEOPTIONS view
Function
Lists the SQL Remote message link parameters and their values, as stored in
the SYSREMOTEOPTION and SYSREMOTEOPTIONTYPE system
tables, in more readable form.
the SYSREMOTEOPTION and SYSREMOTEOPTIONTYPE system
tables, in more readable form.
Columns
Column
Description
type_name
The message link type.
"
option
"
The option name.
setting
The option value.
SYSREMOTEUSERS view
Function
Lists information about remote users and their status.
Columns
Column
Description
user_name
The user ID of the user with REMOTE permissions.
consolidate
The column contains either an N to indicate a user
with REMOTE permissions, or a Y to indicate a user
with CONSOLIDATE permissions.
with REMOTE permissions, or a Y to indicate a user
with CONSOLIDATE permissions.
type_name
The name of the message type used to send messages
to this user.
to this user.
address
The address to which SQL Remote messages are to
be sent. The address must be appropriate for the
address_type.
be sent. The address must be appropriate for the
address_type.
frequency
How frequently SQL Remote messages are to be sent.
send_time
The next time messages are to be sent to this user.
next_send
The next time messages are to be sent to this user, in a
more comprehensible format.
more comprehensible format.
334