SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

B-10

BREAK TITLE Command

BREAK TITLE is an SQLCI report writer command that specifies the text at the

beginning of a group of break column values. You can use BREAK TITLE 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 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



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.



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.



The print list you specify in a BREAK TITLE command is a logical line, although

(depending on margin settings, device widths, and use of the SKIP clause) it might