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_IS_TRACKABLE function [System]

Returns whether or not you can maintain historical data for the specified database server property by storing its tracked values.

Syntax
PROPERTY_IS_TRACKABLE( property-ID )
Parameters
  • property-ID

    The PropNum of the database server property. You can find the PropNum of the database server property by running the sa_eng_properties system procedure or by calling the PROPERTY_NUMBER function.

Returns

1 if the database server property can be tracked; otherwise, returns 0.

Remarks

Only database properties that return a numeric value can be tracked.

Example

The following example returns all database server properties that are trackable:

SELECT PropName FROM sa_eng_properties( ) WHERE PROPERTY_IS_TRACKABLE( PropNum ) = 1;