Informix Error -26811: Can not create temp table with replcheck columns
Cause and resolution
Can not create temp table with replcheck columns
It is not possible to create a temp table with REPLCHECK columns
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26811 fires when a temporary table is created with REPLCHECK columns — per the
official guidance.
- A temporary table defined with
REPLCHECKcolumns, per the official guidance — the direct, only cause; not allowed.
Solutions / Resolution
- Don't specify
REPLCHECKwhen creating a temporary table, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a temp table defined with
REPLCHECK.
Diagnostic Checks
- Check the
CREATE TEMP TABLEstatement forREPLCHECK, and remove it.
Related Errors / Related Topics
- -26812 — "Illegal usage of REPLCHECK columns" The general
REPLCHECK-usage restriction this is a specific temp-table instance of. - -26476 — "Can not create temp table with ERKEY" The same class of restriction, for
ERKEYrather thanREPLCHECK.
A temporary table was defined with REPLCHECK columns, which isn't allowed — remove
them.