SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
10-12
SQL 8402
Where source-data-type(internal-type) is the character string data type (and
an internal representation of the data type) of the column to which the SQL statement
refers.
Where string-value is the character string literal that you specified in the SQL
statement.
Where target-data-type(internal-type) is the character string data type (and
an internal representation of the data type) to which the character string is being
converted.
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. Do not attempt recovery. Contact your service provider.
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.
8402 22001 A string overflow occurred during the evaluation
of a character expression. Conversion of Source Type:
source-data-type(internal-type) Source Value:string-value to
Target Type:target-data-type(internal-type).
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.