"Delete Restrict Rule" errors

FM/Db2 reports a Delete Restrict Rule error if your deletion or change would have deleted one or more rows in dependent tables, but the delete rule is RESTRICT. These are referential integrity (RI) constraint errors.

The error information panel for this error shows the names of the parent and dependent tables in the relationship that caused the error, and the name of the relationship. At the bottom of the panel are the names of the columns that comprise the key in both the parent and dependent tables, along with the value that caused the error.

You can enter the RE prefix command against the row, or enter the REDIT command from the error information panel, to edit the dependent table of the relationship and correct the error.

Related tasks

• Editing related tables

Related references

• REDIT primary command