|
- Causa
- 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:
- directly contains a GROUP BY or HAVING clause
- specifies as its object a view having a definition that includes a GROUP BY or HAVING clause
Neither construct is permitted.
- Ação do sistema
- The statement cannot be executed. No data was retrieved.
- Resposta ao Desenvolvedor
- 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.
SQLSTATE: 42920
© Copyright IBM Corp.
|
| |