KFSP31049-E

A column that does not exist in the column specification list of a GROUP BY clause was specified in a column specification that appears in the comparison operand of a HAVING clause. Query name = aa....aa, incorrect specification = bb....bb

aa....aa: Query name
bb....bb: Incorrect specification
Description:
A data ID not in the column specification list of the GROUP BY clause has been specified in a column specification specified as the comparison operand of the HAVING clause.
System processing:
Stops query registration processing.
Action to take:
Revise the column specification of the comparison operand of the HAVING clause.