Each row in the SYSREMOTEOPTIONTYPE system view describes one of the SQL Remote message link parameters. The underlying system table for this view is ISYSREMOTEOPTIONTYPE.
Column | Data type | Column constraint |
---|---|---|
option_id | UNSIGNED INT | NOT NULL |
type_id | SMALLINT | NOT NULL |
"option" | VARCHAR(128) | NOT NULL |
option_id An identification number for the message link parameter.
type_id An identification number for the message type that uses the parameter.
"option" The name of the message link parameter.
PRIMARY KEY (option_id)
FOREIGN KEY (type_id) references SYS.ISYSREMOTETYPE (type_id)