NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-42
SET SESSION Command
MANDATORY_REPORT { OFF | ON }
specifies whether SQLCI should print a report even if the associated query returns
zero rows. This option has no effect when the associated query returns one or more
rows.
The default when you start SQLCI is MANDATORY_REPORT OFF.
STATISTICS { OFF | ON }
specifies whether to display statistics after each DDL, DML, or DCL command
executes.
The default when you start SQLCI is STATISTICS OFF.
See DISPLAY STATISTICS Command
on page D-49 for a description of the
statistics displayed.
WARNINGS { OFF | ON }
specifies whether to display warning messages. (SQLCI always displays error
messages.)
The default when you start SQLCI is WARNINGS ON.
WRAP { OFF | ON }
specifies whether SQLCI output lines that exceed the output device width are
truncated or continued on the next line.
The default when you start SQLCI is WRAP ON.
OFF Do not print a report when the query does not return any rows. (This is the
default.)
ON Print a report even if the query does not return any rows. The report format uses
current report settings. In addition, the report contains the message “--- No rows
selected.” when the query does not return any rows.
OFF Do not display statistics
ON Display statistics
OFF Do not display warning messages
ON Display warning messages
OFF Continue (wrap around) to the next line
ON Truncate the line if it does not fit