+203   THE QUALIFIED COLUMN NAME column-name WAS RESOLVED USING A NON-UNIQUE OR UNEXPOSED NAME

Explanation

The table designator selected to resolve a qualified column name is one of the following:
  • An unexposed name
  • An exposed name that has an exposed duplicate in the same FROM clause
  • An exposed name that has an unexposed duplicate which appears before the selected name in the ordered list of names to which the qualifier is compared
Therefore, the statement does not conform to the guidelines for using only unique exposed names as qualifiers or it is possible that the column reference was not resolved to the intended instance of the table or view.

System action

DB2® uses the selected name to resolve the reference.

Programmer response

If DB2 did not resolve of the qualifier how you intended, rewrite the SQL statement and submit it again.

SQLSTATE

01552