SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-21
SQL 8227
Cause. Duplicate values for columns requiring unique values are not allowed.
Columns require unique values if they are columns of the primary key or columns of a
unique index.
Effect. The INSERT or UPDATE operation fails.
Recovery. Correct the data values. If the application requires duplicate values, you
could drop the index or redefine and reload the table.
SQL 8228
Cause. You cannot insert or update a row that is not compatible with the constraint.
Effect. The INSERT or UPDATE operation fails.
Recovery. Correct the data for the SQL statement so that the statement does not
produce a row that is incompatible with the constraint, and reissue the statement.
SQL 8229
Cause. The UPDATE statement included a column that was not specified in the FOR
UPDATE column list in the DECLARE CURSOR statement. The cursor declaration
must list any columns that you intend to update.
Effect. The UPDATE operation fails.
Recovery. Correct the cursor declaration to list all of the columns in the FOR UPDATE
clause that you intend to update with an UPDATE WHERE CURRENT OF statement.
SQL 8230
Cause. A subquery was required to return one row, but did not return any rows.
Effect. The statement fails.
Recovery. Check your query and data.
8227 The row being inserted or updated in underlying table
value-1 contains a key value that must be unique but is
already present in a row.
8228 A constraint was violated on underlying table value-1.
8229 Cursor specified in an UPDATE WHERE CURRENT OF request
does not have the required update column list.
8230 No rows were returned by the subquery.