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-46
SQLSTATE Values
22007 -3045 Invalid date 'date'.
22007 -3046 Invalid time 'time'.
22007 -3047 Invalid timestamp 'timestamp'.
22007 -3158 Invalid DATETIME datetime.
22007 -8413 The string argument contains characters that cannot be
converted.
22007 -8415 The provided DATE, TIME, or TIMESTAMP is not valid and
cannot be converted.
22007 -8422 The provided INTERVAL is not valid and cannot be converted.
22008 -8405 The operand of function CONVERTTIMESTAMP is out of
range.
22008 -8407 The operand of function JULIANTIMESTAMP is out of range.
22008 -8416 A datetime expression evaluated to an invalid datetime value.
22011 -8403 The length argument of function SUBSTRING cannot be less
than zero or greater than source string length.
22012 -4075 Division by zero in constant expression name.
22012 -8419 An arithmetic expression attempted a division by zero.
22015 -3044 Invalid interval num.
22019 -8409 The escape character argument of a LIKE predicate must be
one character in length.
22024 -8412 An input character host variable is missing its null terminator.
22025 -8410 An escape character in a LIKE pattern must be followed by
another escape character, an underscore, or a percent
character.
22027 -8404 The trim character argument of function TRIM must be one
character in length.
23000 -8101 The operation is prevented by check constraint name on table
name.
23000 -8102 The operation is prevented by a unique constraint.
23000 -8103 The operation is prevented by referential integrity constraint
name on table name.
23000 -8421 NULL cannot be assigned to a NOT NULL column.
24000 -8004 Trying to open a statement or cursor that is not in the closed
state.
24000 -8005 Trying to fetch from a cursor that is not in the open state.
24000 -8013 Trying to update or delete from a cursor that is not in the
fetched state.
Table 20-1. SQLSTATE Values (page 45 of 85)
SQLSTATE SQLCODE Error Text