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

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

CONNECTION_PROPERTY function [System]

Returns the value of a given connection property as a string.

Syntax
CONNECTION_PROPERTY( 
{ property-id | property-name }
[ , connection-id ] )
Parameters
  • property-id

    The connection property ID.

  • property-name

    The connection property name.

  • connection-id

    The connection ID number of a database connection. The ID number for the current connection is used if a value is not specified.

Returns

VARCHAR, LONG VARCHAR

Remarks

Either the property ID or the property name must be specified.

Privileges

No privileges are required to execute this function for the current connection ID. To execute this function for other connections, you must have either the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.

NULL is returned if you specify an invalid parameter value or don't have one of the required system privileges.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

The following statement returns the number of prepared statements being maintained:

SELECT CONNECTION_PROPERTY( 'PrepStmt' );