SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

Executor Messages (8000 through 8999)
HP NonStop SQL/MX Messages Manual—544518-011
10-6
SQL 8102
Cause. You attempted to perform an operation that is prevented by a unique
constraint.
Effect. NonStop SQL/MX could not perform the operation.
Recovery. Make the data you enter unique to be consistent with the constraint.
SQL 8103
Where name1 is the name of the constraint.
Where name2 is the name of the table.
Cause. You attempted to perform an operation on table name1 that is prevented by
referential integrity constraint name2.
Effect. The operation fails.
Recovery. Change the data you are attempting to enter to be consistent with the
constraint. The data must exist in another table. For example, if you are trying to enter
a department number for an employee, the department number must exist in a
department number table.
SQL 8104
Where view name1 is the name of the view.
Where name2 is the name of the table.
Cause. You attempted to perform an operation on table name1. The operation has
been prevented by the check on view name2, cascaded from the check option on the
table.
Effect. The operation fails.
Recovery. Change the view properties, if appropriate.
8102 The operation is prevented by a unique constraint.
8103 The operation is prevented by referential integrity
constraint name1 on table name2.
8104 The operation is prevented by the check on view name1
cascaded from the check option on name2.