NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-10
SQLCI Commands Used to Write Reports
For more detailed information, see the entries for specific commands, functions, clauses,
or options. (Clauses marked with an asterisk (*) are described in DETAIL Command on
page D-43.) For additional information about using the report writer, see the NonStop
SQL/MP Report Writer Guide.
The uses of these commands, functions, clauses, and options are summarized in the
tables that follow.
The table “SQLCI Commands Used to Write Reports” includes the report writer
commands just listed, as well as other SQLCI commands typically used with report
writer commands.
For example, the SQLCI SET SESSION includes such options as
MANDATORY_REPORT that can affect report format.
The tables “Style and Layout Options for Reports
”, “Report Writer Clauses” and
“Report Writer Functions” summarize, respectively, functions, print-list clauses, and
style and format options available for report writing.
SQLCI Commands Used to Write Reports
Command
Description
BREAK FOOTING Defines text for the end of a break group
BREAK ON Groups lines by item value
BREAK TITLE Defines text for the start of a break group
CANCEL Cancels the current SELECT command
DETAIL Defines detail line content and format
EXECUTE Executes a compiled command
LIST Displays rows returned by a SELECT command
LOG Starts or ends logging of session activity to a file
OUT Specifies or closes the output file
OUT_REPORT Directs the output of a SELECT to a report file or closes the
current report file
PREPARE Compiles a command. Useful for compiling a SELECT
command before producing a report
NAME Defines a name for a column in the select list for use in
reports
PAGE FOOTING Defines text for the bottom of each page
PAGE TITLE Defines text for the top of each page
REPORT
FOOTING
Defines text for the end of the report
REPORT TITLE Defines text for the start of the report
RESET LAYOUT Resets layout options to default settings