← All errors

SQLCODE -545

SQL0545 CHECK constraint violation

IBM message text
INSERT, UPDATE, or MERGE not allowed by CHECK constraint.
SQLCODE
-545
SQLSTATE
23513

Most common cause

The inserted or updated row does not satisfy a CHECK constraint on the table.

Other causes

  • Default values that do not satisfy the constraint.

How to fix it

The message names the constraint: read its condition in QSYS2.CHECK_CONSTRAINTS and fix the data.

Text and codes from IBM documentation for 7.6. Checked on .