ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_eng_properties system procedure

Function 

Reports database server property information.

Syntax 

sa_eng_properties

Permissions 

None

Side effects 

None

See also 

Server-level properties

Description 

Returns the PropNum, PropName, PropDescription, and Value for each available server property.

For a list of available engine properties, see System functions.

Example 

• The following statement returns a set of available server properties

  CALL sa_eng_properties()

  PropNum	PropName	...
  1	IdleWrite	...
  2	IdleChkPt	...
  ...	...	...