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 » System procedures » Alphabetical list of system procedures

sa_eng_properties system procedure

Reports database server property information.

Syntax
sa_eng_properties( )
Result set
Column name Data type Description
PropNum INTEGER The database server property number.
PropName VARCHAR(255) The database server property name.
PropDescription VARCHAR(255) The database server property description.
Value LONG VARCHAR The database server property value.
Remarks

Returns the PropNum, PropName, PropDescription, and Value for each available server property. Values are returned for all database server properties and statistics related to database servers.

Privileges

You must have EXECUTE privilege on the system procedure.

Side effects

None

Example

The following statement returns a set of available server properties

CALL sa_eng_properties( );
PropNum PropName ...
1 IdleWrite ...
2 IdleChkPt ...
... ... ...