NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-3
Examples—REPORT FOOTING
Examples—REPORT FOOTING
•
The following example specifies a report footing that includes both a literal and a
column value:
S> REPORT FOOTING "End of Summary for Sales Representative",
+> SALESREP CENTER;
The footing looks like this:
End of Summary for Sales Representative 212
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)
EMS 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.
[ON ]
REPORT [OFF ]
[TO collector ]