Informix Error -26558: Query contains implicit column
Cause and resolution
Query contains implicit column
This query was not accelerated or probed successfully because it contains an implicit column. Tables contain implicit columns if they are created or altered using the following options:
option | implicit columns -----------------+-------------------------------------- WITH CRCOLS | cdrserver, cdrtime WITH REPLCHECK | ifx_replcheck WITH VERCOLS | ifx_insert_checksum, ifx_row_version WITH ERKEY | ifx_erkey_1, ifx_erkey_2, ifx_erkey_3 WITH ROWIDS | rowid
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26558 fires when a query isn't accelerated/probed successfully because a table involved has implicit columns — per the official guidance.
- A table was created/altered
WITH CRCOLS, per the official guidance — implicitcdrserver/cdrtimecolumns. - A table was created/altered
WITH REPLCHECK, per the official guidance — implicitifx_replcheckcolumn. - A table was created/altered
WITH VERCOLS, per the official guidance — implicitifx_insert_checksum/ifx_row_versioncolumns. - A table was created/altered
WITH ERKEY, per the official guidance — implicitifx_erkey_1/ifx_erkey_2/ifx_erkey_3columns. - A table was created/altered
WITH ROWIDS, per the official guidance — implicitrowidcolumn.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead.
Examples
N/A
No specific triggering statement is documented beyond a table with one of the listed implicit-column options.
Diagnostic Checks
- Check the query's tables for
CRCOLS/REPLCHECK/VERCOLS/ERKEY/ROWIDS, and note that acceleration isn't available for such tables.
Related Errors / Related Topics
- -26476 — "Can not create temp table with ERKEY" A related
ERKEY-usage restriction, on temp tables rather than acceleration eligibility. - -26477 — "Illegal usage of ERKEY" A related
ERKEY-usage restriction, general rather than specific to acceleration eligibility. - -26480 — "Illegal usage of ifx_replcheck" A related
REPLCHECK-column usage restriction, general rather than specific to acceleration eligibility.
The query involved a table with implicit columns (CRCOLS/REPLCHECK/VERCOLS/
ERKEY/ROWIDS) — such queries run on the database server instead.