Informix Error -19815: Cannot create a temp table with CRCOLS.

Cause and resolution

Cannot create a temp table with CRCOLS.

You cannot create a temporary table to include the replication shadow columns.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19815 fires when a temporary table is created with replication shadow columns (CRCOLS) — per the official guidance. Temporary tables can't include CRCOLS.

A temporary table created WITH CRCOLS, per the official guidance — the direct, only cause.

Solutions / Resolution

Create the temporary table without WITH CRCOLS, per the official guidance.

Examples

A temp table with CRCOLS

CREATE TEMP TABLE mytemp (id INT) WITH CRCOLS;
-- -19815: temp tables can't have replication shadow columns

Corrected

CREATE TEMP TABLE mytemp (id INT);

Diagnostic Checks

Check the CREATE TEMP TABLE statement for WITH CRCOLS, and remove it.

Related Errors / Related Topics

-19812 — "Illegal usage of replication shadow columns." The general restriction this is a specific case of, for temporary tables.

A temporary table can't be created with CRCOLS — omit WITH CRCOLS.