DB2 SQL-Error: -338
SQLState: 42972
Short Description: AN ON CLAUSE IS INVALID
This return code reports a violation of one of the following: v One expression of the predicate must only reference columns of one of the operand tables of the associated join operator, full join, and the other expression of the predicate must only reference columns of the other operand table. v A VALUE or COALESCE function is allowed in the ON clause only when the join operator is a FULL OUTER JOIN or FULL JOIN. v An operator other than Â’=Â’ is not allowed in a FULL OUTER JOIN or FULL JOIN. v A subquery is not allowed in the ON clause.System action: The statement cannot be executed. Programmer response: Correct the syntax so that it doesnÂ’t violate any of the above items within the ON clause