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||Column 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.|
PRIMARY KEY (service_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|