Difference between revisions of "SET SYSLOGGING"

Revision as of 16:26, 26 October 2009

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
...
EXEC SQL
  SELECT * FROM syslogging;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer