Informix Error -3650

-3650 You must first remove table-name rows which join this row.

The row you wish to remove is the dominant member of a verify join. You cannot remove this row without first removing any rows that join it.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3650 fires when attempting to remove a row that's the dominant member of a verify join — per the official guidance, the row can't be removed without first removing any rows in table-name that join to it.

Attempting to remove a dominant row still referenced by joining rows in table-name, per the official guidance — the direct, only cause.

Solutions / Resolution

Remove the joining rows in table-name first, per the official guidance, then remove the dominant row.

Examples

Removing dependent rows first

DELETE FROM order_items WHERE cust_id = '12345';
-- then remove the dominant customer row via the form

Diagnostic Checks

Check table-name for rows still joining to the row being removed, and remove them first.

Related Errors / Related Topics

-2920 — "The column column is a dominant column but it is not indexed." A related dominant-column warning, about a missing index on the dominant column rather than dependent rows blocking removal.
-3265 — "A required index on column-name is missing. Restore." A related runtime dominant-column error, about a missing index rather than dependent rows blocking removal.

The row being removed is a dominant verify-join row with dependent rows in table-name — remove those rows first.