ALTER SERVICE service-name
[ TYPE { 'RAW' | 'HTML' | 'JSON' | 'XML' } ]
[ URL [ PATH ] { ON | OFF | ELEMENTS } ]
[ common-attributes ]
[ AS { statement | NULL } ]

common-attributes:
[ AUTHORIZATION { ON | OFF } ]
[ ENABLE | DISABLE ]
[ METHODS 'method,...' ]
[ SECURE { ON | OFF } ]
[ USER { user-name | NULL } ]

method:
DEFAULT
| POST
| GET
| HEAD
| PUT
| DELETE
| NONE
| *

ALTER SERVICE service-name
[ TYPE 'SOAP' ]
[ DATATYPE { ON | OFF | IN | OUT } ]
[ FORMAT { 'DNET' | 'CONCRETE' [ EXPLICIT { ON | OFF } ] | 'XML' | NULL } ]
[ common-attributes ]
[ AS statement ]

ALTER SERVICE service-name
[ TYPE 'DISH' ]
[ GROUP { group-name | NULL } ]
[ FORMAT { 'DNET' | 'CONCRETE' [ EXPLICIT { ON | OFF } ]| 'XML' | NULL } ]
[ common-attributes ]

The descriptions of the ALTER SERVICE clauses are identical to those of the CREATE SERVICE statement. See CREATE SERVICE statement.

The ALTER SERVICE statement modifies the attributes of a web service.

DBA authority

None.

• CREATE SERVICE statement
• DROP SERVICE statement
• Tutorial: Using SQL Anywhere to access a SOAP/DISH service
• SYSWEBSERVICE system view
• -xs dbeng12/dbsrv12 server option
• Using SQL Anywhere as an HTTP web server

The following example demonstrates how to disable an existing web service using the ALTER SERVICE statement:

CREATE SERVICE WebServiceTable
   AUTHORIZATION OFF
   USER DBA
   AS SELECT *
      FROM SYS.SYSTAB;

ALTER SERVICE WebServiceTable DISABLE;