Run 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 general HTTP web services include HTML, XML, RAW and JSON. For more information about supported web service types, see Choosing a web service type.

You can view the generated result set for the SampleWebService service by accessing the service in a web browser. See Browsing an HTTP web server.

• Choosing a web service type
• CREATE SERVICE statement
• ALTER SERVICE statement