Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

PROPERTY function [System]

Returns the value of the specified database server property as a string.

Syntax
PROPERTY( {  property-id | property-name }  [, second-parameter ] )
Parameters
  • 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.
    EventTypeName positive-integer Specify an event ID to return the event type name.
    FunctionMaxParms positive-integer Specify a function number to return the maximum number of parameters that can be specified for the function.
    FunctionMinParms positive-integer Specify a function number to return the minimum number of parameters that must be specified for the function.
    FunctionName positive-integer Specify a function number to return the function name.
    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.
    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.
    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.
    RemoteCapability positive-integer Specify a remote capability ID to return the remote capability name associated with the ID.
Returns

VARCHAR, LONG VARCHAR

Remarks

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.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

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

SELECT PROPERTY( 'Name' );