HP NonStop SQL/MX, Messages Manual

Page: 698 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -46
SQLSTATE Values
22003 -8411 A numeric overflow occurred during an arithmetic computation
or data conversion.
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.
Table 21-1. SQLSTATE Values (page 45 of 84)
SQLSTATE SQLCODE Error Text