ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the value of a given connection property as a string.
CONNECTION_PROPERTY (
{ integer-expression-1 | string-expression }
[ , integer-expression-2 ] )
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.
The current connection is used if the second argument is omitted.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise.
PROPERTY_NUMBER function [System]
The following statement returns the number of prepared statements being maintained.
SELECT connection_property( 'PrepStmt' )