← All errors

SQLCODE -205

SQL0205 Column not in table

IBM message text
Column &1 not in table &2 in &3.
SQLCODE
-205
SQLSTATE
42703

Most common cause

The column, qualified with a table name or correlation name, is not in that table.

Other causes

  • The correlation name points to the wrong table in the join.

How to fix it

Check the columns with QSYS2.SYSCOLUMNS or DSPFFD, and fix the qualifier.

Related errors

Text and codes from IBM documentation for 7.6. Checked on .