SQL/MP Messages Manual

SQLCI Messages (10000 to 10999)
HP NonStop SQL/MP Messages Manual—427720-006
12-66
SQL 10647
Cause. A nonnumeric column was specified in a TOTAL or SUBTOTAL command.
Only numeric columns can be totaled or subtotaled.
Effect. The command is ignored.
Recovery. Reissue the command, using only numeric columns.
SQL 10648
Cause. A SUBTOTAL or BREAK TITLE or BREAK FOOTING command or a
LINE_NUMBER function was specified for a column that is not a BREAK column.
Effect. No report is generated.
Recovery. Enter a BREAK command for the specified column, or reissue the
command that treats the column as a BREAK column.
SQL 10649
Cause. A SUBTOTAL command was specified, but there are no break columns to
subtotal.
Effect. The command is ignored.
Recovery. Enter a BREAK command or delete the SUBTOTAL command, using
RESET.
10647 value-1 is nonnumeric. All total and subtotal items
must be numeric.
10648 You have specified subtotals or break title or break
footing or line_number on value-1. You must specify a break
on value-1 before the LIST command.
10649 You have a SUBTOTAL command but no BREAK command. The
SUBTOTAL command is being ignored in the report output.