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


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 -811

   
 
  • Causa
    • THE RESULT OF AN EMBEDDED SELECT STATEMENT OR A SUBSELECT IN THE SET CLAUSE OF AN UPDATE STATEMENT IS A TABLE OF MORE THAN ONE ROW, OR THE RESULT OF A SUBQUERY OF A BASIC PREDICATE IS MORE THAN ONE VALUE.

      Execution of an embedded SELECT statement or a subselect in the SET clause of an UPDATE statement has resulted in a result table that contains more than one row.
      Alternatively, a subquery contained in a basic predicate has produced more than one value.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Examine the syntax of the statement to ensure that it contains the proper condition specifications.
      If the statement syntax is correct, there might be a problem with the data that is causing more than one row or value to be returned when you do not expect it.

      SQLSTATE: 21000
© Copyright IBM Corp.