CONNECTION_PROPERTY function [System]

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

Syntax

CONNECTION_PROPERTY( 
{ property-id | property-name }
[ , connection-id ] )

Parameters

property-id
The connection property ID.
property-name
The connection property name.
connection-id
The connection ID number of a database connection. The ID number for the current connection is used if a value is not specified.

Returns

VARCHAR, LONG VARCHAR

Remarks

Either the property ID or the property name must be specified.

Privileges

No privileges are required to execute this function for the current connection ID. To execute this function for other connections, you must have either the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.

NULL is returned if you specify an invalid parameter value or don't have one of the required system privileges.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

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

SELECT CONNECTION_PROPERTY( 'PrepStmt' );