SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-41
SET SESSION Command
ERROR_TEXT { DETAIL | BRIEF }
specifies the default information SQLCI displays when you enter an ERROR
command. You can override the ERROR_TEXT option with the ERROR command.
The default when you start SQLCI is ERROR_TEXT DETAIL.
LIST_COUNT { number | ALL }
specifies how many rows of data from a SELECT command to display before a
pause.
The default when you start SQLCI is LIST_COUNT ALL.
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.
For a description of the statistics displayed, see DISPLAY STATISTICS Command
on page D-52.
DETAIL Display error text, cause, effect, and suggestions for recovery
BRIEF Display only the error text
number Display number rows
ALL Display all the rows of the result table
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