informix -268错误

zllzll123

求救::::  informix -268错误 大虾们是什么意思啊。

liaosnet

-268    Unique constraint <constraint-name> violated.

During execution of this statement, a duplicate value was introduced
into a column or columns that a unique constraint protects. The row
with the duplicate value was not allowed into the table (not inserted
or not updated). For IBM Informix Dynamic Server, any changes that this statement
made prior to the discovery of the duplicate value have been rolled back. (The
effects of preceding statements in the transaction, if there were any, remain
in effect. They must be explicitly rolled back or committed.)

This error occurs in a logging database. However, if you are using
repeatable read isolation, error -239 will display instead.


有违反约束的数据出现。。。。。

xxyyy

-268错误指新插入的数据或正在更改的数据出现了2行或多行重复，并且重复部分是表的主键部分。
-239指数据重复，重复部分是表的唯一索引而非主键。