SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Messages Manual—523730-004
5-4
SQL 3011
Where name is the name specified in the operation.
Cause. You specified an invalid name name, which must have three or fewer parts.
catalog.schema.table is valid. catalog.schema.table.name is invalid.
Effect. The operation fails.
Recovery. Correct the name and resubmit.
SQL 3012
Cause. You submitted an AVG or other aggregate function that does not allow (*) as
an operand. Only COUNT allows you to use (*).
Effect. The operation fails.
Recovery. Remove the (*) operand and resubmit.
SQL 3013
Cause. You specified an expression with invalid syntax. Only subtraction is supported
in the parenthesized expression that precedes an interval qualifier.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 3014
Cause. You defined a numeric item, value, with precision greater than 18, which is
not supported.
Effect. The operation fails.
Recovery. Redefine the item with a precision value of 18 or less.
3011 name is not a valid qualified name; it has more than 3
name parts.
3012 COUNT is the only aggregate function that accepts (*) as
an operand.
3013 Subtraction is the only operation allowed in the
parenthesized expression preceding an interval qualifier.
3014 Precision of numeric, value, cannot exceed 18.