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.