SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-88
SUBTOTAL_LABEL Option
The report looks like this:
DEPTNUM JOBCODE SALARY BONUS
------- ------- --------------- ------------
1000 100 137000.10 3425.00
--------------- ------------
* 137000.10 3425.00
500 25000.75 625.02
29000.00 725.00
50000.00 1250.00
--------------- ------------
* 104000.75 2600.02
--------------- ------------
* 260000.85 6500.02
1500 100 90000.00 2250.00
--------------- ------------
* 90000.00 2250.00
600 26000.00 650.00
32000.00 800.00
--------------- ------------
* 58000.00 1450.00
900 17000.00 425.00
--------------- ------------
* 17000.00 425.00
--------------- ------------
* 165000.00 4125.00
SUBTOTAL_LABEL Option
SUBTOTAL_LABEL is an option of the SQLCI report writer command SET STYLE.
SUBTOTAL_LABEL specifies a label to print in a break column on the same line as a
subtotal.
label
is a character string to use as a label. label consists of 0 to 255 single-byte
characters or 0 to 127 double-byte characters. The default is * (asterisk).
Considerations—SUBTOTAL_LABEL

The report writer uses the same subtotal label for all groups. The label prints in the
break column associated with the subtotal and is truncated if it does not fit. For
more information and for a sample report with subtotal labels, see SUBTOTAL
Command on page S-86.

If you do not want subtotal labels to print, specify an empty string (“”) in the
SUBTOTAL_LABEL command.
SUBTOTAL_LABEL "label"