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.

Syntax

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

Permissions

None

Side effects

None

See also
Example

The following statement returns a set of available server properties

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