SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Messages Manual—544518-011
10-11
SQL 8402
Cause. If the SQLSTATE is 22001, this is an error. You attempted to use a character
expression whose length caused a string overflow.
If the SQLSTATE is 01004, this is a warning. You attempted to use a character
expression whose length caused a string overflow.
Effect. If this is an error, The operation fails. If this is a warning, your string is
truncated.
Recovery. Increase the field size of the receiving field.
SQL 8403
Cause. You specified a SUBSTRING function with an invalid length argument: less
than zero or greater than the source string length.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 8404
Cause. You specified a TRIM function with an invalid trim character argument, which
must be one character in length.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 8405
Cause. You attempted to reference the operand of a CONVERTTIMESTAMP function
that is out of range.
Effect. The operation fails.
8402 22001 A string overflow occurred during the evaluation
of a character expression.
8403 The length argument of function SUBSTRING cannot be less
than zero or greater than source string length.
8404 The trim character argument of function TRIM must be one
character in length.
8405 The operand of function CONVERTTIMESTAMP is out of
range.