Sybase Adaptive Server Anywhere - Page 375

Chapter 8 SQL Functions
357
PROPERTY_DESCRIPTION ( { property-id | property-name } )
property-id An integer that is the property-number of the database
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 database property.
The following statement returns the description Number of index
insertions.
SELECT PROPERTY_DESCRIPTION( ’IndAdd’ )
Each property has both a number and a name, but the number is subject to
change between releases, and should not be used as a reliable identifier for a
given property.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"Database Performance and Connection Properties" on page 1081
PROPERTY function [System]
Returns the value of the specified server-level property as a string.
PROPERTY ( { property-id | property-name } )
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 database property.
The following statement returns the name of the current database server:
SELECT PROPERTY( ’Name’ )
Each property has both a number and a name, but the number is subject to
change between releases, and should not be used as a reliable identifier for a
given property.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"Server-level properties" on page 1095
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also