User's 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.
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.
type_name The name of the message type 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 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.
334