PL/I · DB2 SQLCODE

SQLCODE +206: Column Is Not a Column of the Referenced Table

What does SQLCODE +206: Column Is Not a Column of the Referenced Table mean in PL/I?

An embedded INSERT, UPDATE, or SELECT references a column name that doesn't belong to the table or view named in the statement — often a typo, or a DCLGEN-based host structure that's out of sync with the table's actual DDL after a column rename.

SQLCODE +206: Column Is Not a Column of the Referenced TableDB2 for z/OS · PL/I (embedded SQL)

Condition

An embedded INSERT, UPDATE, or SELECT references a column name that doesn't belong to the table or view named in the statement — often a typo, or a DCLGEN-based host structure that's out of sync with the table's actual DDL after a column rename.

Fix

Regenerate the DCLGEN from the current table definition and recompile, and double-check that FROM-clause correlation names match the column references used in the EXEC SQL block.

Related db2 sqlcode