SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-3
REPORT Option
REPORT Option
The REPORT option controls generation of EMS messages for an SQL operation
started by a statement that includes the option.
If you specify REPORT without an option, the default is ON.
If you omit the REPORT clause entirely, the default is OFF.
ON
directs event messages for the operation to $0, the default EMS collector.
OFF
suppresses event messages for the operation.
TO collector
directs event messages for the operation to collector. collector is the name
of a primary or alternate EMS collector (or an equivalent DEFINE).
Considerations—REPORT Option

EMS (Event Management Service) is a collection of processes, tools, and
interfaces that provide event-message collation and distribution in the DSM
(Distributed Systems Management) environment. A few SQL statements send
EMS messages (also called event messages) that allow you to monitor the
progress of the operation started by the statement. These statements include the
REPORT option to allow you to control the generation of such messages and
specify the collector to which the messages are sent.
For more information about EMS in general, see the EMS Manual. For more
information about EMS messages issued by SQL/MP software, see the SQL/MP
Messages Manual.

The EDIT file RPTSQL on the subvolume on which NonStop SQL/MP is installed
(normally $SYSTEM.SYSTEM) contains a TACL script that generates EMS reports
for SQL operations. You can use it to produce default reports or customize a copy
of it to produce variations on the default reports.
For more information, see the comments within the file RPTSQL itself.
Examples—REPORT Option

This CREATE INDEX example uses the REPORT option to explicitly turn on the
sending of EMS messages associated with the operation. Because the REPORT
[ON ]
REPORT [OFF ]
[TO collector ]