Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|