SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

X-13

Default Event Messages

If the =_SQL_CMP_EVENT_NO0 DEFINE does not exist, the SQL compiler issues a

message to $0 whenever an automatic recompilation occurs.

The event messages contain these fields:

86 SQLCOMP type datetime file PID=pid E=err FS=fs-err

Compiler event messages displayed on the console have an EMS subsystem ID rather

than an SQL ID, because SQL compiler event messages are not EMS messages. The

compiler sends the messages to $0, where they are converted to EMS messages and

given an EMS subsystem ID.

Consideration—=_SQL_CMP_EVENT_NO0

=_SQL_CMP_EVENT_NO0 affects only event messages issued within the TACL or

SQLCI session in which the DEFINE is in effect.

You cannot globally disable the logging of such messages to $0 except to have each

TACL process on the node add the =_SQL_CMP_EVENT_NO0 DEFINE.

Example—=_SQL_CMP_EVENT_NO0

This TACL command directs the SQL compiler not to send event messages regarding

automatic recompilations from the TACL or SQLCI session to $0:

32> ADD DEFINE =_SQL_CMP_EVENT_NO0, CLASS MAP, FILE NOFILE

type PROG (indicating automatic recompilation of an entire program) or

STMT (indicating automatic of a single statement)

datetime the date and time of the compilation

file the name of the program file

pid identifies the process that started the compiler (a process name, if

any, or a processor and PIN)

err the SQL error that caused the automatic recompilation

fs-err the file-system error that caused the automatic recompilation