Specifying an HTTP scheme within the URL clause configures the procedure or function for non-secure communication using an HTTP protocol.

The following statement illustrates how to create a procedure that sends requests to a web service named SampleWebService that resides in a database named dbname hosted by an HTTP web server located at localhost on the default port:

CREATE PROCEDURE MyOperation ()
    URL 'HTTP://localhost/dbname/SampleWebService'

The database name is only required if the HTTP server hosts more than one database. You can substitute localhost with host name or the IP address of the HTTP server.

For more information about starting an HTTP server with these sample specifications, see Starting an HTTP web server.

Specifying an HTTPS scheme within the URL clause configures the procedure or function for secure communication over Secure Socket Layer. (SSL)

Your web client application must have access to the server certificate or the certificate that signs the server certificate to issue a secure HTTPS request. The certificate is required for the client procedure in order to authenticate the server to prevent man-in-the-middle exploits.

Use the CERTIFICATE clause of the CREATE PROCEDURE and CREATE FUNCTION statements to authenticate the server and establish a secure data channel. You can either place the certificate in a file and provide the file name, or provide the entire certificate as a string value; you cannot do both.

The following statement demonstrates how to create a procedure that sends requests to a web service named SampleWebService that resides in a database named dbname in an HTTPS server located at localhost on the default port:

CREATE PROCEDURE MyOperation ()
    URL 'HTTPS://localhost/dbname/SampleWebService'
    CERTIFICATE 'file=C:\srv_cert.id;co=Sybase;unit=SA;name=JohnSmith';

The CERTIFICATE clause in this example indicates that the server certificate is located in the C:\srv_cert.id file.

For more information about starting an HTTP web server with these sample specifications, see Starting an HTTP web server.

Some requests need to be sent through a proxy server. Use the PROXY clause of the CREATE PROCEDURE and CREATE FUNCTION statements to specify the proxy server URL and redirect requests to that URL. The proxy server forwards the request to the final destination, obtains the response, and forwards the response back to SQL Anywhere.