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

Conclusão: 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.

Ação do sistema: The statement cannot be executed.

Resposta ao Desenvolvedor: Refer to Chapter 4 of DB2 SQL Reference for information about restrictions on the syntax of the HAVING clause.

SQLSTATE: 42906