DSNH206I W csectname LINE nnnn COL cc STATEMENT REFERENCES COLUMN column name WHICH IS NOT DECLARED IN THE SPECIFIED TABLE(S)

Explanation

The column column name is not contained in any TABLE declaration for the tables specified in the statement.

Start of changeThe Db2 coprocessor or Db2 precompiler issues this message during limited semantic checking of data references in the SQL statements of a program, so it might not be issued for some table or column references. Also, the checks are done against table declarations in the program and not the Db2 catalog. For more information about the limitations of the semantic checking, see Processing SQL statements for program preparation.End of change

System action

Processing continues.

System programmer response

Check the spelling of the column name. Ensure that all the tables needed were specified in the statement.

User response

If the table declares are correct and the column name is not in the tables, this creates an error in the BIND step. Correct the DECLARE TABLE statements or the column name.

Severity

4 (warning)