+012 THE UNQUALIFIED COLUMN NAME `column-name` WAS INTERPRETED AS A CORRELATED REFERENCE

Explanation
 The column name does not identify a column of
a table or view in the FROM clause of the subquery. However, it does
identify a column of a table or view in a FROM clause at a higher
level in the statement.

System action
 The column name is interpreted as a correlated
reference.

Programmer response
 If Db2 interpretates the column name differently than you intended, rewrite the SQL statement and submit it again. If you intend the column name to refer to a table named at a higher level, we advise rewriting the statement anyway, using a table name or correlation name as a qualifier for the column name. The unqualified column name could be interpreted differently if you do a rebind after altering one of the tables to which you refer.

SQLSTATE
 01545

+012 THE UNQUALIFIED COLUMN NAME column-name WAS INTERPRETED AS A CORRELATED REFERENCE

Explanation

System action

Programmer response

SQLSTATE

+012 THE UNQUALIFIED COLUMN NAME `column-name` WAS INTERPRETED AS A CORRELATED REFERENCE