1.15.3 If message KFAA30119-E is displayed
Check whether the column specified immediately after the SELECT is different from the column specified in the GROUP BY clause.
Example 1:
SELECT "USERID",COUNT(*) FROM "SALESLIST" GROUP BY "PUR-CODE" KFAA30119-E In a query using a GROUP BY clause or a set function specification, the column "USERID" specified in a select expression, a HAVING clause or an ORDER BY clause must be specified as an argument of the GROUP BY clause or the set function. (query number = 1, 1)
In this example, the underlined portions of the statement are incorrect. Make the column names specified in the underlined portions the same.
Example 2:
SELECT "USERID","PUR-CODE",COUNT(*) FROM "SALESLIST" GROUP BY "USERID" KFAA30119-E In a query using a GROUP BY clause or a set function specification, the column "PUR-CODE" specified in a select expression, a HAVING clause or an ORDER BY clause must be specified as an argument of the GROUP BY clause or the set function. (query number = 1, 1)
In this example, the underlined portions of the statement are incorrect. Make the number of columns and the column names specified in the underlined portions the same.