SQL - SQLCODE's - Códigos negativos -815


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -815

   
 
  • 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.