CONNECTION_PROPERTY function [System]

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

integer-expression-1 It is usually 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 Accessing connection property values.
integer-expression-2 The connection ID of the current database connection. The current connection is used if this argument is omitted.

VARCHAR, LONG VARCHAR

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

Cloud note: Because of tenant database isolation rules, when this function is called in the cloud it returns only information about the current tenant database.

SQL/2008 Vendor extension.

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

SELECT CONNECTION_PROPERTY( 'PrepStmt' );

CONNECTION_PROPERTY function [System]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example