Informix Error -26813: Can not add REPLCHECK when the table already has REPLCHECK columns
Cause and resolution
Can not add REPLCHECK when the table already has REPLCHECK columns
The table already has REPLCHECK columns.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26813 fires when ALTER TABLE adds REPLCHECK to a table that already has it — per
the official guidance.
- The table already has
REPLCHECKcolumns, per the official guidance — the direct, only cause.
Solutions / Resolution
- Don't re-add
REPLCHECKto a table that already has it, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond re-adding REPLCHECK.
Diagnostic Checks
- Check whether the table already has
REPLCHECKcolumns, and skip theALTER TABLE ADDif so.
Related Errors / Related Topics
- -26812 — "Illegal usage of REPLCHECK columns" The general
REPLCHECK-usage restriction this is a specific instance of. - -26814 — "Can not drop REPLCHECK when table does not have REPLCHECK columns" The
mirror-image error, on dropping
REPLCHECKthat isn't present rather than adding it when already present.
REPLCHECK was added to a table that already has it — skip the ALTER TABLE.