SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-9
Report Writer
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
RESET REPORT Deletes commands from the current report definition, or deletes
columns or alias from stored report formatting commands in the
current report definition
RESET SESSION Resets session options to default settings
RESET STYLE Resets style options to default settings
SELECT Retrieves data from tables and views
SET LAYOUT Sets layout options to new values
SET SESSION Sets session options to new values
SET STYLE Sets style options to new values
SHOW LAYOUT Displays the values of layout options
SHOW REPORT Displays report formatting commands and the most recent SELECT
command
SHOW SESSION Displays values of session options
SHOW STYLE Displays values of style options
SUBTOTAL Defines subtotals
TOTAL Defines totals
Table R-1. SQLCI Commands Used to Write Reports (page 2 of 2)