HP NonStop SQL/MX, Messages Manual

Page: 258 / 752

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Messages Manual — 640324-001
10 -10
SQL 8350
Where
set1
and
set2
are the character sets of two character types.
Cause. The two character sets are different. As a result, an assignment between the
two character types cannot be made.
Effect. The operation fails.
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.
8350 Character set set1 and set2 are not assignment
compatible.
8400 Define name1 should have a name2 class attribute.
8401 21000 A row subquery or SELECT...INTO statement cannot
return more than one row.