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.