User's Manual

Chapter 15. System Objects for Adaptive Server Anywhere
Column Data type Description
option_id UN-
SIGNED INT
An identification number for the
message link parameter.
type_id SMALLINT An identification number for the
message type that uses this parameter
"option" VAR-
CHAR(128)
The name of the message link pa-
rameter.
SYSREMOTETYPE table
Function Each row describes one of the SQL Remote message types, including the
publisher address.
Columns
Column Data type Description
type_id SMALLINT An identification number for the
message type.
type_name VAR-
CHAR(128)
The message type. There is a sepa-
rate row for each of the following:
♦ FILE
♦ MAPI
♦ VIM
♦ SMTP
publisher_-
address
VAR-
CHAR(128)
The publisher’s address for the mes-
sage type type_name. SQL Remote
receives messages from this address.
remarks LONG VAR-
CHAR
Comments
SYSREMOTEUSER table
Function Each row describes a user ID with REMOTE permissions (a subscriber),
together with the status of SQL Remote messages sent to and from that user.
Columns
329