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