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

Returns extended connection properties. The returned value is a VARCHAR.

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.

• Connection properties
• CONNECTION_PROPERTY function [System]
• DB_EXTENDED_PROPERTY function [System]
• DB_PROPERTY function [System]

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' );