Neoview Messages Manual (Volume 1) (R2.4)

SQL 8402
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).
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.
string-value
is the character string literal that you specified in the
SQL statement.
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. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 8403
8403 The length argument of function SUBSTRING cannot be less than zero
or greater than source string length.
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 Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 8404
8404 The trim character argument of function TRIM must be one character
in length.
Cause You specified a TRIM function with an invalid trim character argument, which must
be one character in length.
Effect The operation fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 8405
8405 The operand of function CONVERTTIMESTAMP is out of range.
Cause You attempted to reference the operand of a CONVERTTIMESTAMP function that
is out of range.
Effect The operation fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
181