Difference between revisions of "SYSLOGGING"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 43: Line 43:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
EXEC SQL
+
SELECT user_name, level FROM syslogging
SELECT user_name, level
+
FROM syslogging;
+
 
</code>
 
</code>
  

Latest revision as of 16:50, 22 December 2009

Purpose

Provides System Logging information. 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.


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
LEVEL N 1 Logging level: 0-FATAL, 1-ERROR, 2-WARNING, 3-INFORMATION, 4-LOGON/LOGOFF
PID N 8 Process ID
USER_NAME C 30 User name
DATE D 4 Date logged
TIME C 8 Time logged
FILE_NAME C 10 Internal
LINE_NUMBER N 6 Internal
OS_ERROR_NUMBER N 4 OS error number
PRODUCT_NAME C 28 Name of logging product
PATCH_LEVEL C 30 Patch level of logging product
COMPILE_DATETIME C 20 Compile date of logging product
MESSAGE C 100 Textual information


Example

SELECT user_name, level FROM syslogging


Products

Recital, Recital Server