ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

CONNECTION_PROPERTY function [System]

Function 

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

Syntax 

CONNECTION_PROPERTY (
{ integer-expression-1 | string-expression }
[ , integer-expression-2 ] )

Parameters 

integer expression-1    In most cases it is more convenient to supply a string expression as the first argument. If you do supply an integer-expression, it is the connection property ID. You can determine this using the PROPERTY_NUMBER function.

string-expression    The connection property name. Either the property ID or the property name must be specified.

For a list of connection properties, see Connection-level properties.

integer-expression-2     The connection ID of the current database connection. The current connection is used if this argument is omitted.

Usage 

The current connection is used if the second argument is omitted.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

Connection-level properties

PROPERTY_NUMBER function [System]

Example 

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

SELECT connection_property( 'PrepStmt' )