SYSREMOTETYPE system view

The SYSREMOTETYPE system view contains information about SQL Remote. The underlying system table for this view is ISYSREMOTETYPE.

Column name Data type Description
type_id SMALLINT Identifies which of the message systems supported by SQL Remote is to be used to send messages to the user.
object_id UNSIGNED BIGINT The internal ID for the remote type, uniquely identifying it in the database.
type_name CHAR(128) The name of the message system supported by SQL Remote.
publisher_address LONG VARCHAR The address of the remote database publisher.
remarks LONG VARCHAR Remarks about the remote type. This value is stored in the ISYSREMARK system table.
 Constraints on underlying system table