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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |