SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-12
Considerations—=_SQL_CMP_EVENT
Considerations—=_SQL_CMP_EVENT

If you use =_SQL_CMP_EVENT to direct compiler event messages regarding
automatic recompilations (PROG and STMT type events) to a home terminal, the
home terminal used is the home terminal for the process that invoked the SQL
compiler. This selection is normally the home terminal for the executing TACL for
SQLCI session, but you can specify a different home terminal for the process by
specifying the TERM option in the RUN command that executes the process.
You cannot direct other types of event messages from the SQL compiler to the
home terminal, and you cannot direct event messages regarding automatic
compilations to a different terminal or to both a file and the home terminal.

You cannot globally direct SQL compiler event messages from other processes on
a node to a file or home terminal; each affected TACL or SQLCI session must have
its own =_SQL_CMP_EVENT DEFINE in effect, although multiple users can direct
messages to the same file.
Examples—=_SQL_CMP_EVENT

This example creates a file called LOGFILE on volume $X subvolume Y and
directs the SQL compiler to send event messages there, as shown:
30> FUP CREATE LOGFILE, TYPE E, REC 102, NO AUDIT;
31> ADD DEFINE =_SQL_CMP_EVENT, CLASS MAP, FILE $X.Y.LOGFILE;
The DEFINE affects only SQL compiler messages from a TACL process in which
the DEFINE is in effect. After the file is created, however, users of other TACL
processes can direct compiler messages to the same file by adding a similar
DEFINE.

This TACL command directs the SQL compiler to log PROG and STMT events to
the user's terminal by specifying a nonexistent file for the =_SQL_CMP_EVENT
DEFINE:
32> ADD DEFINE =_SQL_CMP_EVENT, CLASS MAP, FILE NOFILE;
=_SQL_CMP_EVENT_NO0 DEFINE
=_SQL_CMP_EVENT_NO0 is a system DEFINE that suppresses event messages that
the SQL compiler normally sends to $0 when automatic recompilations occur.
filename
must be a legal Guardian file name but has no purpose except to make the ADD
DEFINE command syntactically correct.
ADD DEFINE =_SQL_CMP_EVENT_NO0, CLASS MAP, FILE filename