PROPERTY function [System]

Function

Returns the value of the specified server-level property as a string.

Syntax

PROPERTY ( { property-id  | property-name } )

Parameters

property-id An integer that is the property-number of the server-level property. This number can be determined from the PROPERTY_NUMBER function. The property-id is commonly used when looping through a set of properties.

property-name A string giving the name of the property. See “Properties available for the server” for a list of server property names.

Example

The following statement returns the name of the current database server:

SELECT PROPERTY( 'Name' ) FROM iq_dummy

Usage

Each property has both a number and a name, but the number is subject to change between versions, and should not be used as a reliable identifier for a given property.

Standards and compatibility

See also

“Properties available for the server”