SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Messages Manual—523730-004
10-9
Recovery. Determine why the two character types have different character sets and
make them agree (for example, properly declare the character set of the host variable
or use the SQL function TRANSLATE).
SQL 8400
Cause. The CLASS attribute of the DEFINE is not correct. For example, the CLASS
attribute for an MP table name DEFINE should be MAP, not SORT.
Effect. The operation fails.
Recovery. Use a correct CLASS attribute as specified in the SQL/MX Programming
Manual for C and COBOL.
SQL 8401
Cause. The table or tables had more than one row that satisfied the query. Only one
row is allowed.
Effect. The operation fails.
Recovery. Determine if the statement or the data is incorrect. If the data is incorrect,
correct the data. If the INTO clause is incorrect, use a cursor to select and fetch the
data. Use an INTO clause only when you expect one row to satisfy the SELECT
statement. If the subquery is incorrect, rewrite the SELECT query.
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.
8400 Define name1 should have a name2 class attribute.
8401 A row subquery or SELECT...INTO statement cannot return
more than one row.
8402 22001 A string overflow occurred during the evaluation
of a character expression.