CREATE TABLE SYS.SYSWEBSERVICE ( service_id UNSIGNED INT NOT NULL, service_name CHAR(128) NOT NULL, service_type VARCHAR(40) NOT NULL, auth_required CHAR(1) NOT NULL, secure_required CHAR(1) NOT NULL, url_path CHAR(1) NOT NULL, user_id UNSIGNED INT, parameter VARCHAR(250) statement LONG VARCHAR, remarks LONG VARCHAR, super_type_id SMALLINT NULL, UNIQUE ( type_name ), PRIMARY KEY ( service_id ) ) )
Each row holds a description of a web service.
service_id A unique identifying number for the web service.
service_name The name assigned to the web service.
service_type The type of the service, for example, RAW, HTTP, XML, SOAP, or DISH.
auth_required (Y/N) Indicates whether all requests must contain a valid user name and password.
secure_required (Y/N) Indicates whether insecure connections, such as HTTP, are to be accepted, or only secure connections, such as HTTPS.
url_path Controls the interpretation of URLs.
user_id 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 A prefix that identifies the SOAP services to be included in a DISH service.
statement 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.
