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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_enable_auditing_type system procedure Next Page

sa_eng_properties system procedure

Reports database server property information.


sa_eng_properties( )

Result set
Column nameData typeDescription
PropNumINTEGERThe database server property number.
PropNameVARCHAR(255)The database server property name.
PropDescriptionVARCHAR(255)The database server property description.
ValueLONG VARCHARThe database server property value.

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. For a list of available database server properties, see System functions.



Side effects


See also

The following statement returns a set of available server properties

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