SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—640324-001
21-60
SQLSTATE Values
42000 -4072 The operand of function name must be a datetime containing a
name.
42000 -4073 The COLLATE clause might appear only after an expression of
character data type, not type.
42000 -4076 Overflow in constant expression name.
42000 -4077 Function name accepts only one or two operands.
42000 -4078 Function name does not accept a weight operand.
42000 -4079 The operands of function name must be numeric.
42000 -4080 SQL/MP error: num num.
42000 -4081 SQL/MP error: num
42000 -4082 Table name does not exist or is inaccessible.
42000 -4084 SQL object table name is corrupt.
42000 -4086 Environment variable or define name does not exist.
42000 -4087 Prototype value 'name' is not a valid qualified name.
42000 -4088 The number of values in each TRANSPOSE item of a
TRANSPOSE set must be equal.
42000 -4093 The number of output dynamic parameters (num) must equal
the number of selected values (num).
42000 -4094 The number of output host variables (num) must equal the
number of selected values (num).
42000 -4095 A DEFAULT whose value is NULL is not allowed in name.
42000 -4097 A NULL operand is not allowed in function name.
42000 -4098 A NULL operand is not allowed in operation name.
42000 -4099 A NULL operand is not allowed in predicate name.
42000 -4100 A NULL value is not allowed in a select list unless it is CAST
to some data type.
42000 -4101 If name is intended to be a further table reference in the FROM
clause, the preceding join search condition must be enclosed
in parentheses.
42000 -4104 If a character literal was intended, you must use the single
quote delimiter instead of the double: name instead of name.
42000 -4105 Unknown translation.
42000 -4106 The character set for the operand of function name must be
name.
42000 -4107 Column name has no default value, so DEFAULT cannot be
specified.
42000 -4108 Inside a ROWS SINCE, another sequence function contained
an invalid reference to the THIS function.
Table 21-1. SQLSTATE Values (page 59 of 84)
SQLSTATE SQLCODE Error Text
To Next Page