Execute the following statement in Interactive SQL to create a sample general HTTP web service in the HTTP web server:

CREATE SERVICE SampleWebService
    TYPE 'web-service-type-clause'
    URL OFF
    USER DBA
    AUTHORIZATION OFF
    AS sql-statement;

The CREATE SERVICE statement creates a new web service named SampleWebService and returns the result set of sql-statement. You can replace sql-statement with either a SELECT statement to select data from a table or view directly, or a CALL statement to call a stored procedure in the database. For more information about creating stored functions and procedures for your web services, see Developing web service applications in an HTTP web server.

Replace web-service-type-clause with the desired web service type. Valid clauses for HTTP web services include HTML, XML, RAW and JSON.

You can view the generated result set for the SampleWebService service by accessing the service in a web browser.

• Web service types
• CREATE SERVICE statement [HTTP web service]
• ALTER SERVICE statement [HTTP web service]
• Browsing an HTTP web server