Logging information to ObjectServer files (WRITE INTO command)
Use the WRITE INTO command to write logging information to ObjectServer files. For example, you can use the command to write output from a trigger to a log file. An ObjectServer file is a logical file, which has a corresponding file or set of files on the physical file system.
The
files have a defined maximum size. When this size is reached, a new
file is created. There is a maximum number of files. When the maximum
size and maximum number of files are exceeded, the files are rotated.
During file rotation, do not open the log files with exclusive write
access (for example, by using Microsoft Excel), because the ObjectServer cannot rotate the
files.
Syntax
WRITE INTO file_name [ VALUES ] (expression, ...);
A carriage return follows each message.
Example
The following command adds a message to the physical file associated with the ObjectServer file file1 each time a user connects to a database.
WRITE INTO file1 VALUES
('User', %user.user_name, 'connected to the system at', getdate );
The %user.user_name user variable used in this example is only available in procedures and triggers.