In this post, you’ll learn about the error message -120 a where or set clause includes column function or a where clause references column col-name which is derived from a column function or expression in a view definition in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-120 a where or set clause includes column function or a where clause references column col-name which is derived from a column function or expression in a view definition
Reason for the Error
A column function is not permitted in a SET clause.� A column function is allowed in a WHERE clause only if the WHERE clause appears within a subquery of a HAVING clause.
Solution
Change the statement so that the aggregate function or OLAP specification is not specified in a context where it is not allowed.
