DB2 Error Code – -133 a column function in a subquery of a having clause is invalid because all column references in its argument are not correlated to the group by result that the having clause is applied to

In this post, you’ll learn about the error message -133 a column function in a subquery of a having clause is invalid because all column references in its argument are not correlated to the group by result that the having clause is applied to in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-133 a column function in a subquery of a having clause is invalid because all column references in its argument are not correlated to the group by result that the having clause is applied to

Reason for the Error

If a column function has a correlated column reference, it must be correlated from within a HAVING clause to the GROUP BY result that the HAVING clause is applied to.� All column references in the argument must satisfy this condition.

Solution

Correct the syntax of the HAVING clause.