NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-8
Considerations—REPORT TITLE
CENTER
centers each line of the report title between the left and right margins. If you omit
CENTER, the report title starts immediately after the left margin.
Considerations—REPORT TITLE
•
A blank line separates the report title from the body of the report. The report title
appears below the page title on the first page.
•
Each REPORT TITLE command replaces the previous one. Only one REPORT
TITLE command is in effect at a time. When you enter a REPORT TITLE
command, it replaces the previous REPORT TITLE command.
•
The print list is limited to 4072 bytes of printed output. The output of a REPORT
TITLE command is a logical line, even though (depending on margin settings,
device widths, and use of the SKIP clause) it might print on more than one physical
line. A logical line is limited to 4072 bytes, including the field widths of all print
items and the number of spaces between items.
Examples—REPORT TITLE
•
The following commands select data for a report and define list count:
>> SET LIST_COUNT 0;
>> SELECT * FROM SALES.ORDERS, PERSNL.EMPLOYEE
+> WHERE SALESREP = EMPNUM AND
+> SALESREP = 226;
•
The following example defines a report title, defines a detail line that omits the
SALESREP column, and lists all selected rows. Other elements of the report use the
default report format.
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