Web Service Maintenance

Web service maintenance involves the following tasks:

• Creating or altering web services – Create or alter web services to provide web applications supporting a web browser interface and provide data interchange over the web using REST and SOAP methodologies.
• Dropping web services – Dropping a web service causes the subsequent requests made for that service to return a 404 Not Found HTTP status message. All unresolved requests, intended or unintended, are processed if a root web service exists.
• Commenting on web services – Commenting is optional and allows you to provide documentation for your web services.
• Creating and customizing a root web service – You can create a root web service to handle HTTP requests that do not match any other web service requests.
• Enabling and disabling web services – A disabled web service returns a 404 Not Found HTTP status message. The METHOD clause specifies the HTTP methods that can be called for a particular web service.

• How to Create or Alter a Web Service
  Creating or altering a web service requires use of the CREATE SERVICE or ALTER SERVICE statement, respectively. This section illustrates how to execute these statements with Interactive SQL to create different kinds of web services. The examples in this section assume that you have connected to an SAP Sybase IQ database, your-database.db, through Interactive SQL using the following command:
• How to Drop a Web Service
  Dropping a web service causes the subsequent requests made for that service to return a 404 Not Found HTTP status message. All unresolved requests, intended or unintended, are processed if a root web service exists.
• How to Comment a Web Service
  Providing documentation for a web service requires use of the COMMENT ON SERVICE statement. A comment can be removed by setting the statement clause to null.
• How to Create and Customize a Root Web Service
  An HTTP client request that does not match any web service request is processed by the root web service if a root web service is defined.
• Web Service SQL Statements
  The following SQL statements are available to assist with web service development: