SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
B-6
BREAK FOOTING Command
BREAK FOOTING Command
BREAK FOOTING is an SQLCI report writer command that specifies the text at the
end of a group of break column values. You can use BREAK FOOTING only from the
select-in-progress prompt, not from the SQLCI prompt.
break-column
identifies a break column (a column named in a BREAK ON command). It can be a
column name, an alias, a detail alias, or COL number (which specifies the position
of the column in the select list).
print-item
specifies the contents and format of items to print when the value in the break
column changes. print-item is the same as described under the DETAIL
command except that it cannot include the HEADING, NOHEAD, or NAME
clauses. For more information, see DETAIL Command on page D-47 or Print Item
on page P-28.
If print-item is a column identifier, the column value will be the one from the last
select row in the group.
CENTER
centers each line of the break footing between the left and right margins. If you
omit CENTER, the break footing is positioned at the left margin.
Considerations—BREAK FOOTING

If you define break footings, you must enter a BREAK ON command that includes
the break column identifier in each BREAK FOOTING command before you list
any output.

Only one BREAK FOOTING command is in effect for each break column. If you
enter another BREAK FOOTING command for the same break column, the most
recent command replaces the previous BREAK FOOTING command for that
column.

The print list you specify in a BREAK FOOTING command is a logical line,
although (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
BREAK FOOTING break-column (print-list) [CENTER];
print-list is:
print-item [, print-item] ...