Alters an existing web service.
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.
SQL/2008 Vendor extension.
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;