SYSWEBSERVICE system view

Each row in the SYSWEBSERVICE system view holds a description of a web service. The underlying system table for this view is ISYSWEBSERVICE.

Column name Data type Description
service_id UNSIGNED INT A unique identifying number for the web service.
object_id UNSIGNED BIGINT The ID of the webservice.
service_name CHAR(128) The name assigned to the web service.
service_type VARCHAR(40) The type of the service; for example, RAW, HTTP, XML, SOAP, or DISH.
auth_required CHAR(1) Whether all requests must contain a valid user name and password.
secure_required CHAR(1) Whether insecure connections, such as HTTP, are to be accepted, or only secure connections, such as HTTPS.
url_path CHAR(1) Controls the interpretation of URLs.
user_id UNSIGNED INT If authentication is enabled, identifies the user, or group of users, that have permission to use the service. If authentication is disabled, specifies the account to use when processing requests.
parameter LONG VARCHAR A prefix that identifies the SOAP services to be included in a DISH service.
statement LONG VARCHAR A SQL statement that is always executed in response to a request. If NULL, arbitrary statements contained in each request are executed instead. Ignored for services of type DISH.
remarks LONG VARCHAR Remarks about the webservice. This value is stored in the ISYSREMARK system table.
enabled CHAR(1) Indicates whether the web service is currently enabled or disabled (see CREATE SERVICE).

Constraints on underlying system table

PRIMARY KEY (service_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
UNIQUE Constraint (service_name)