RPG (IBM i / AS/400) · DB2 SQLCODE
What does SQLCODE -206 - Column Not Found mean in RPG (IBM i / AS/400)?
A SELECT, UPDATE, or other SQL statement referenced a column name that doesn't exist in the specified table or view, often after a column was renamed or dropped but the SQLRPGLE source wasn't updated to match.
A SELECT, UPDATE, or other SQL statement referenced a column name that doesn't exist in the specified table or view, often after a column was renamed or dropped but the SQLRPGLE source wasn't updated to match.
Check the column spelling against the current table/view definition, and recompile the program after any DDL change to the underlying tables so host variable and SELECT list references stay in sync.