Informix Error -26093: Table (%s) is not the source table.
Cause and resolution
Table (%s) is not the source table.
This error is generated when a user tries to insert data into the target table using the column from the target table. For example:
create table bonus (id int, bonus int); create table emp(id int, salary int);
MERGE INTO bonus D USING emp S ON D.id = S.id WHEN MATCHED THEN UPDATE SET bonus = bonus + salary*.01 WHEN NOT MATCHED THEN INSERT (D.id, D.bonus) VALUES (D.id, salary);
This will generate the following error because the salary column in the VALUE clause is not from the source table, emp:
26093: Table (d) is not the source table. Error in line 4 Near character position 61
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26093 fires when a MERGE statement's VALUES clause qualifies a column with a table
name that isn't the source table — per the official guidance.
- The
VALUESclause uses a table-qualified column reference naming the target table (or another table) instead of the source table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Qualify
VALUES-clause references with the source table's own name/alias, per the official guidance, or leave them unqualified.
Examples
A target-table-qualified column in the VALUES clause
MERGE INTO bonus D
USING emp S ON D.id = S.id
WHEN MATCHED THEN UPDATE SET bonus = bonus + salary*.01
WHEN NOT MATCHED THEN INSERT (D.id, D.bonus) VALUES (D.id, salary);
-- -26093: D.id qualifies with D (bonus, the target), not the source table emp
Corrected
MERGE INTO bonus D
USING emp S ON D.id = S.id
WHEN MATCHED THEN UPDATE SET bonus = bonus + salary*.01
WHEN NOT MATCHED THEN INSERT (D.id, D.bonus) VALUES (S.id, salary);
Diagnostic Checks
- Check every table-qualified column reference in the
VALUESclause, and confirm the qualifier is the source table.
Related Errors / Related Topics
- -26091 — "Table (%s) is not the target table." The mirror-image error, on the
INSERTcolumn list qualifying with a table other than the target. - -26092 — "Column (%s) is not found in the source table." A related
MERGEcolumn- scoping error, on an unqualified column name from the wrong table rather than a wrong table qualifier.
The VALUES clause qualified a column with a table other than the source table — use the
source table's own qualifier or none.