MainframeKit

-205

SQLSTATE 42703NEGATIVE SQLCODE

The statement names a column that the given table does not have. Usually a typo, a wrong table qualifier, or a column not yet added in this environment.

MOST LIKELY

A misspelled column name.

FIRST CHECK

Read the column and table names from the message.

TRY IT ▸

MainframeKit assistant

What it means

The SQL refers to a column as belonging to a specific table, but that table has no column of that name. Db2 cannot run the statement and returns -205 with SQLSTATE 42703. The message tokens give both the column name and the table name Db2 checked.

Typical causes

  • A misspelled column name.
  • The column belongs to a different table than the one named or qualified.
  • The column was added in test but the ALTER has not reached this environment.
  • The table qualifier points at an older copy of the table without the new column.

How to fix it

  1. Read the column and table names from the message.
  2. List the table's columns in SYSIBM.SYSCOLUMNS and compare spelling.
  3. Check the table qualifier and which schema the program is bound against.
  4. If the column should exist, ask the DBA to apply the missing ALTER, then rerun.