DB2 SQL-Error: -815
SQLState: 42920
Short Description: A GROUP BY OR HAVING CLAUSE IS IMPLICITLY OR EXPLICITLY SPECIFIED IN A SUBSELECT OF A BASIC PREDICATE OR THE SET CLAUSE OF AN UPDATE STATEMENT
A subselect of a basic predicate or a SET clause of an UPDATE statement either: v directly contains a GROUP BY or HAVING clause v specifies as its object a view having a definition that includes a GROUP BY or HAVING clauseNeither construct is permitted. System action: The statement cannot be executed. No data was retrieved. Programmer response: The implied function is not supported by DB2. No coding workaround exists for the subselect. A GROUP BY or HAVING clause cannot be used within the subselect of a basic predicate because the subselect is allowed to return only a single value. For more information on basic predicates, refer to DB2 SQL Reference.