Previous Topic: -166 - TBL authid.tblname CHECK PENDINGNext Topic: -168 - THE TABLE ALREADY HAS A PRIMARY KEY, ONLY ONE MAY BE DEFINED


-167 - DOMAIN CONSTRAINT nnnnnnnn.mmmmmmmm VIOLATION

Explanation

You attempted to insert or update a row. This action violated the constraint named mmmmmmmm. The nnnnnnnn is the schema ID (creator) of the constraint, and the mmmmmmmm is the name of the constraint.

The SQLSTATE that equates to this SQL return code is 23513.

User Response

Query the SYSCONSTRSRC table to view information about the constraint. You may either drop the constraint or modify the selection criteria (or whatever is causing the violation in the update or delete statement) so that it does not violate the constraint.