Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » HTTP web services » SQL Anywhere as an HTTP web server » How to develop web service applications in an HTTP web server


Web services connection properties

Web service connection properties can be database properties that are accessible using the CONNECTION_PROPERTY function.

Use the following syntax to store a connection property value from the HTTP server to a local variable in a SQL function or procedure:

SELECT CONNECTION_PROPERTY('connection-property-name') INTO variable_name;

The following is a list of useful runtime HTTP request connection properties that are commonly used for web service applications:

  • HttpServiceName   Returns the service name origin for a web application.

  • AuthType   Returns the type of authentication used when connecting.

  • ServerPort   Returns the database server's TCP/IP port number or 0.

  • ClientNodeAddress   Returns the node for the client in a client/server connection.

  • ServerNodeAddress   Returns the node for the server in a client/server connection.

  • BytesReceived   Returns the number of bytes received during client/server communications.

 See also