SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-8
Report Writer
For more information, see the entries for specific commands, functions, clauses, or
options. Clauses marked with an asterisk (*) are described in DETAIL Command
on
page D-47. For more information about using the report writer, see the SQL/MP Report
Writer Guide.
The uses of these commands, functions, clauses, and options are summarized in the
tables that follow.
Table R-1 includes the report writer commands just listed, in addition to 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.
Table R-2 on page R-10, Table R-3 on page R-10, and Table R-4 on page R-11
summarize, respectively, functions, print-list clauses, and style and format options
available for report writing.
Clauses
AS Clause
IF/THEN/ELSE Clause SKIP*
AUDIT File Attribute
NEED* SPACE Option*
CONCAT Clause
PAGE* TAB*
Functions
COMPUTE_TIMESTAMP
Function
LINE_NUMBER Function
CURRENT_TIMESTAMP
Function
PAGE_NUMBER Function
Table R-1. SQLCI Commands Used to Write Reports (page 1 of 2)
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
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