PROPERTY_NUMBER function [System]

Function

Returns the property number of the property with the supplied property name.

Syntax

PROPERTY_NUMBER ( property-name )

CIS functional compensation performance considerations apply. See “Conditions that cause processing by SQL Anywhere” in Chapter 3, “Optimizing Queries and Deletions,” in the Performance and Tuning Guide.

Parameters

property-name A property name. For property names, see the lists in “Connection properties”, “Properties available for the server”, and “Properties available for each database”.

Example

The following statement returns an integer value. The actual value changes from version to version.

SELECT PROPERTY_NUMBER( 'PAGESIZE' ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension

Sybase Not supported by Adaptive Server Enterprise

See also

“Connection properties”

“Properties available for the server”

“Properties available for each database”