NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Z-11
Examples—=_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.
•
Direction of event messages applies only for TACL or SQLCI
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
•
The following commands create a file called LOGFILE on volume $X subvolume Y
and direct 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.
•
The following 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