Informix Error -19990: Use of CRCOLS must be consistent across the table hierarchy.

Cause and resolution

Use of CRCOLS must be consistent across the table hierarchy.

If the parent table in a table hierarchy has been created with the WITH CRCOLS option for replication shadow columns, then all subtables must also be created with the WITH CRCOLS option. Similarily, if the parent table in the table hierarchy has not been created with the WITH CRCOLS option, then all subtables cannot be created with the WITH CRCOLS option.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19990 fires when a subtable's WITH CRCOLS usage doesn't match its parent table's — per the official guidance.

A parent table created WITH CRCOLS but a subtable created without it, per the official guidance — the first named case.
A parent table created without WITH CRCOLS but a subtable created with it, per the official guidance — the second named case.

Solutions / Resolution

Match every subtable's WITH CRCOLS usage to its parent table's, per the official guidance.

Examples

Inconsistent CRCOLS across a hierarchy

CREATE TABLE parent (id INT) WITH CRCOLS;
CREATE TABLE child (extra INT) UNDER parent;
-- -19990: child must also use WITH CRCOLS

Corrected

CREATE TABLE child (extra INT) WITH CRCOLS UNDER parent;

Diagnostic Checks

Check WITH CRCOLS usage on every table in the hierarchy, and align subtables with the parent.

Related Errors / Related Topics

-19812 — "Illegal usage of replication shadow columns." The general CRCOLS restriction this is a specific case of, for table-hierarchy consistency.

CRCOLS usage must match between a parent table and its subtables.