The following SQL statements are available to assist with web service development:
| Web server related SQL statements | Description |
|---|---|
| CREATE SERVICE statement [HTTP web service] |
Creates a new HTTP web service. |
| CREATE SERVICE statement [SOAP web service] |
Creates a new SOAP over HTTP or DISH service. |
| ALTER SERVICE statement [HTTP web service] |
Alters an existing HTTP web service. |
| ALTER SERVICE statement [SOAP web service] |
Alters an existing HTTP over SOAP or DISH service. |
| COMMENT statement |
Stores a comment for a database object in the system tables. Use the following syntax to comment on a web service: COMMENT ON SERVICE 'web-service-name'
IS 'your comments'
|
| DROP SERVICE statement |
Drops a web service. |