SET SYSLOGGING

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Enable or disable internal system logging


Syntax

SET SYSLOGGING ON | OFF | (<expL>)


See Also

DB_LOGDIR, Configuration Files, ERROR(), MESSAGE(), SYSLOGGING System Table


Description

When SET SYSLOGGING is ON internal system logging is performed while the process is running. The information logged can be used to find performance problems or track down system errors.

All the logging information is written to a file called recital.log. If the environment variable DB_LOGDIR is not defined, then the log files are created in the root directory, otherwise the log files will be created in the specified directory.

This command allows the optional logical expression <expL> to be evaluated. If a value of .T. is returned, SYSLOGGING is set ON. If a value of .F. is returned, SYSLOGGING is set OFF. By default SYSLOGGING is OFF.

SYSLOGGING information can be accessed in table format via the SYSLOGGING System Table.


Example

set syslogging on
...
SELECT * FROM syslogging


Products

Recital Server, Recital