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. 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.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|