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). |
PRIMARY KEY (service_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
UNIQUE Constraint (service_name)