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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

COMPRESS function [String] Next Page

CONNECTION_EXTENDED_PROPERTY function [String]


Returns the value of the given property. Allows an optional property-specific string parameter to be specified.

Syntax

CONNECTION_EXTENDED_PROPERTY(
{ property-id | property-name }
[, property-specific-argument ]
)

Parameters

property-id    The connection property ID.

property-name    The connection property name. Possible property names are CharSet and NcharCharSet.

property-specific-argument    Optional property-specific string parameter associated with the following connection properties.

Remarks

The CONNECTION_EXTENDED_PROPERTY function returns extended connection properties. The returned value is a LONG VARCHAR, and applies to the current connection.

The CONNECTION_EXTENDED_PROPERTY function is similar to the CONNECTION_PROPERTY function except that it allows an optional property-specific string parameter to be specified. The interpretation of the property-specific argument depends on the property ID or name specified in the first argument.

You can use the CONNECTION_EXTENDED_PROPERTY function to return the value for any connection property. However, extended information is only available for the extended properties.

See also
Standards and compatibility
Example

The following example returns the CHAR character set of the current connection as it is known by the Java standard:

SELECT CONNECTION_EXTENDED_PROPERTY( 'charset', 'Java' );