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


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 -533
   
 
  • Causa
    • INVALID MULTIPLE-ROW INSERT.

      An INSERT operation with a subselect attempted to insert multiple rows into a self-referencing table.

      The subselect of the INSERT operation should return no more than one row of data.
  • Ação do sistema
    • The INSERT statement cannot be executed.
      The contents of the object table are unchanged.
  • Resposta ao Desenvolvedor
    • Examine the search condition of the subselect to make sure that no more than one row of data is selected.

      SQLSTATE: 21501

© Copyright IBM Corp.