NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
B-11
Considerations—BREAK TITLE
print-item
specifies the contents and format of items to print as the break title. print-item
is the same as described under DETAIL, except that it cannot include the
HEADING, NOHEAD, or NAME clauses.
If print-item is a column identifier, the column value used is the one from the
first row in the new group.
CENTER
centers each line of the break title between the left and right margins. If you omit
CENTER, the break title is positioned at the left margin.
Considerations—BREAK TITLE
•
BREAK ON is required
If you define break titles, you must enter a BREAK ON command that includes the
break column identifier in each BREAK TITLE command before listing any output.
•
Each BREAK TITLE command replaces the previous BREAK TITLE.
Only one BREAK TITLE command is in effect for each break column. If you enter
another BREAK TITLE command for the same break column, the most recent
command replaces the previous BREAK TITLE command for that column.
•
Print List is limited to 4072 bytes of printed output
The print list you specify in a BREAK 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—BREAK TITLE
•
The following commands select data and identify DEPTNUM as a break column:
>> SELECT D.DEPTNUM, DEPTNAME, EMPNUM, JOBCODE
+> FROM PERSNL.EMPLOYEE E, PERSNL.DEPT D
+> WHERE E.DEPTNUM = D.DEPTNUM
+> ORDER BY D.DEPTNUM;
S> DETAIL D.DEPTNUM, EMPNUM, JOBCODE;
S> BREAK ON COL 1;