Returns the value of the specified database server property as a string.
PROPERTY( { property-id | property-name } [, second-parameter ] )
property-id An integer that is the property-number of the database server 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.
second-parameter You can specify a second parameter for some properties, as follows:
Property | Second parameter | Description |
---|---|---|
EventTypeDesc | positive-integer | Specify an event ID to return the event type description. See EventTypeDesc server property. |
EventTypeName | positive-integer | Specify an event ID to return the event type name. See EventTypeName server property. |
FunctionMaxParms | positive-integer | Specify a function number to return the maximum number of parameters that can be specified for the function. See FunctionMaxParms server property. |
FunctionMinParms | positive-integer | Specify a function number to return the minimum number of parameters that must be specified for the function. See FunctionMinParms server property. |
FunctionName | positive-integer | Specify a function number to return the function name. See FunctionName server property. |
Message | positive-integer | Specify a line number to return the contents of the corresponding line in the database server messages window, prefixed by the date and time the message appeared. See Message server property. |
MessageText | positive-integer | Specify a line number to return the text associated with the specified line number in the database server messages window, without a date and time prefix. See MessageText server property. |
MessageTime | positive-integer | Specify a line number to return the date and time associated with the specified line number in the database server messages window. See MessageTime server property. |
RemoteCapability | positive-integer | Specify a remote capability ID to return the remote capability name associated with the ID. See RemoteCapability server property. |
VARCHAR, LONG VARCHAR
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/2008 Vendor extension.
The following statement returns the name of the current database server:
SELECT PROPERTY( 'Name' ); |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |