SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-17
RESET REPORT Command
report-cmd
is the name of a report-formatting command to reset to its default setting, or (if you
specify column or alias with the command name) with which to delete the
specified column name or alias.
You can specify the report-cmd option only at the select-in-progress prompt, S>.
The report formatting commands and their default settings are:
For example, entering “RESET REPORT TITLE, DETAIL;” at the S> prompt
deletes the title for the current report and resets the detail line to the default detail
line.
The keyword BREAK refers to the BREAK ON command. If you delete a break,
you automatically delete the break footings, break titles, and subtotals associated
with that break. For example, entering “RESET REPORT BREAK PARTS;” at the
S> prompt deletes a break set on the PARTS column and any break footings,
break titles and subtotals associated with that break. Other breaks remain in effect.
column
specifies a column to delete from the stored report command. You can specify
column as a column name, an alias, or COL number (which specifies the position
of the column in the select list). column cannot be a detail alias.
*
resets all report formatting commands to their default settings. If entered at the
standard SQLCI prompt (>>), * also resets the most recent SELECT command.
SELECT
deletes the most recent SELECT command from the report definition.
You can specify the SELECT option only at the standard SQLCI prompt, >>.
BREAK No breaks
BREAK FOOTING No break footing
BREAK TITLE No break title
DETAIL Default report detail line
NAME No names
PAGE FOOTING No page footing
PAGE TITLE No page title
REPORT FOOTING No report footing
REPORT TITLE No report title
SUBTOTAL No subtotals
TOTAL No totals