Log_write

sql

PROCEDURE Log_write (IN text CLOB);

Parameters

text text, that should be written into the server log

Since version

5.1

Description

This procedure writes a new row with the text text in the server log.

The log this procedure is writing into is specified by the setting done by the _sqp_trace function. The default log is the basic log in the wbsqllog.txt, whose current contents are simultaneously displayed in the server window.

If you want to write into any log and with optional context extent, use the _sqp_log_write procedure instead.

Example (SQL)

CALL Log_write("OrderHeader "||"ol_cnt="||CAST(xol_cnt AS CHAR(10)));