Each row of the SYSCAPABILITY system view identifies a capability of a remote server. The underlying system table for this view is ISYSCAPABILITY.
Column name | Column type | Column constraint |
---|---|---|
capid | INTEGER | NOT NULL |
srvid | UNSIGNED INT | NOT NULL |
capvalue | CHAR(128) | NOT NULL |
capid The ID of the capability, as listed in the SYSCAPABILITYNAME system view.
srvid The server to which the capability applies, as listed in the SYSSERVER system view.
capvalue The value of the capability.
PRIMARY KEY (capid, srvid)
FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)
FOREIGN KEY (capid) references SYS.ISYSCAPABILITYNAME (capid)