SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-7
Report Writer
S> REPORT TITLE "Summary of Orders:", SALESREP,
+> CONCAT (FIRST_NAME STRIP, " ", LAST_NAME);
S> DETAIL COL 1, COL 2, COL 3, COL 5;
S> LIST ALL;
Summary of Orders: 226 HEIDI WEIGL
ORDERNUM ORDER_DATE DELIV_DATE CUSTNUM
---------- ---------- ----------- -------
200490 880319 881101 123
300380 880319 880820 123
600480 880512 881010 3333
Report Writer
The report writer is a component of SQLCI that enables you to produce formatted
reports from rows returned by SELECT statements. It includes:
BREAK FOOTING
Command
OUT_REPORT
COMMAND
RESET REPORT
Command
BREAK ON Command PAGE FOOTING
Command
RESET STYLE Command
BREAK TITLE Command PAGE TITLE Command SET LAYOUT Command
CANCEL Command REPORT FOOTING
Command
SET STYLE Command
DETAIL Command REPORT TITLE
Command
SUBTOTAL Command
NAME Command RESET LAYOUT
Command
TOTAL Command
Style and Layout Options
CENTER_REPORT
Option
NEWLINE_CHAR Option ROWCOUNT Option
DATE_FORMAT Option NULL_DISPLAY Option SUBTOTAL_LABEL
Option
DECIMAL_POINT Option OVERFLOW_ CHAR
OPTION
TIME_FORMAT Option
HEADINGS Option PAGE_COUNT Option UNDERLINE_CHAR
Option
LEFT_MARGIN Option PAGE_LENGTH Option VARCHAR_WIDTH Option
LINE_SPACING Option RIGHT_MARGIN Option WINDOW OPTION
LOGICAL_FOLDING
Option
SPACE Option