SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-11
=_SQL_CMP_EVENT DEFINE
=_SQL_CMP_EVENT DEFINE
=_SQL_CMP_EVENT is a system DEFINE that directs the SQL compiler to log
compiler event messages to a file or to the home terminal.
filename
must be a legal Guardian file name.
If the named file is an existing, entry-sequenced file, the compiler sends compiler
event messages to the file. If the file does not exist or is not an entry-sequenced
file, the compiler sends only messages for compiler events of type STMT and
PROG and sends the messages to the home terminal.
Format of SQL Compiler Event Messages
SQL compiler event messages can be up to 102 characters long.
Log files with shorter record lengths receive truncated messages.
The event messages contain these fields:
86 SQLCOMP type datetime file PID=pid E=err FS=fs-err
The types of events are;
ADD DEFINE =_SQL_CMP_EVENT, CLASS MAP, FILE filename
type Type of event that occurred
datetime Date and time of the compilation
file Name of the program file that was compiled
pid Process that started the compiler (a process name, if any, or a
processor and PIN)
err SQL error that caused the automatic recompilation. (Appears only on
messages of type PROG or STMT.)
fs-err File-system error that caused the automatic recompilation. (Appears
only on messages of type PROG or STMT.)
BTCH Recompilation and registration of a program by RESTORE
PREP Compilation of one statement by a run-time PREPARE statement or an
EXECUTE IMMEDIATE command from SQLCI
PROG Automatic recompilation of a program at run time
STAT Explicit compilation
STMT Automatic recompilation of one statement at run time