SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-34
SQL 8404
Effect. Not all characters could fit in the target buffer.
Effect. The statement fails.
Recovery. Check your data or data buffers (host variables). If necessary, declare
larger host variables.
SQL 8405
Cause. Bad data was supplied for decimal values.
Effect. The statement fails.
Recovery. Correct the decimal data.
SQL 8406
Cause. Either a negative number was supplied, or an arithmetic expression produced
a negative value that had an unsigned data type buffer as a target.
Effect. The statement fails.
Recovery. Check your host variables to verify that no unsigned host variables receive
negative numbers, or check arithmetic expressions. Correct the problem and reissue
the statement or rerun the program.
SQL 8407
Cause. An intermediate result was too small to be held in the internal buffers, or data
was too small to fit into the target buffers for INSERT or UPDATE fields.
Effect. The statement fails.
Recovery. Check the data for INSERT or UPDATE operations, to see if intermediate
result underflow occurred. Use simpler arithmetic expressions in the statement.
8404 Truncation of a character data value required, but not
allowed.
8405 Decimal data encountered with some nonnumeric digits.
8406 Tried to assign a negative value to an unsigned numeric
buffer.
8407 Underflow occurred during arithmetic computation or
during INSERT or UPDATE of a numeric column.