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. See HttpServiceName connection property.
AuthType Returns the type of authentication used when connecting. See AuthType connection property.
ServerPort Returns the database server's TCP/IP port number or 0. See ServerPort connection property
ClientNodeAddress Returns the node for the client in a client/server connection. See ClientNodeAddress connection property
ServerNodeAddress Returns the node for the server in a client/server connection. See ServerNodeAddress connection property
BytesReceived Returns the number of bytes received during client/server communications. See BytesReceived connection property

For a complete list of SQL Anywhere connection properties, see Connection properties.

Discuss this page in DocCommentXchange.