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

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-52
SQLSTATE Values
42000 -3012 COUNT is the only aggregate function that accepts (*) as an
operand.
42000 -3013 Subtraction is the only operation allowed in the parenthesized
expression preceding an interval qualifier.
42000 -3014 Precision of numeric, value, cannot exceed 18.
42000 -3015 Scale value cannot exceed precision value.
42000 -3016 Precision of decimal, value, cannot exceed 18.
42000 -3017 Expected an unsigned integer, not value.
42000 -3018 Expected an unsigned smallint, not value.
42000 -3019 Expected an unsigned number within the parentheses, not
value.
42000 -3020 Expected an unsigned number as the first operand within the
parentheses, not value.
42000 -3021 Expected an unsigned number as the second operand within
the parentheses, not value.
42000 -3025 The format of the subvolume name part in the specified
location name name is invalid. The subvolume name part must
be eight characters long and begin with the letters ZSD.
42000 -3026 A comma must be used to separate file attributes.
42000 -3027 name is not a valid simple name; it has more than one name
part.
42000 -3037 Precision of type data type cannot exceed 18.
42000 -3038 PIC X types cannot have leading signs, or any signs at all.
42000 -3039 PIC X types do not have any COMP representation.
42000 -3040 Precision zero is invalid. Add a '9' to the PICTURE clause.
42000 -3041 UNSIGNED is invalid for a numeric or decimal type with a
scale greater than 9.
42000 -3042 UPSHIFT for a numeric type is invalid.
42000 -3043 Precision greater than 18 for a COMP numeric type is invalid.
42000 -3048 Dynamic parameters, such as name, are not allowed in a static
compilation.
42000 -3049 Host variables, such as name, are not allowed in a dynamic
compilation.
42000 -3050 The constraint must have the same catalog and schema as
the specified table.
42000 -3051 Duplicate HEADING clauses in column definition name.
42000 -3052 Duplicate NOT NULL clauses in column definition name.
42000 -3053 Duplicate PRIMARY KEY clauses in column definition name.
Table 20-1. SQLSTATE Values (page 51 of 85)
SQLSTATE SQLCODE Error Text