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


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 -907
   
 
  • Causa
    • AN ATTEMPT WAS MADE TO MODIFY THE TARGET TABLE, table-name, OF THE MERGE STATEMENT BY CONSTRAINT OR TRIGGER trigger-name.

      The MERGE statement caused a constraint or trigger to activate.
      The trigger attempted to update, insert into or delete from the target table or a table within the same table hierarchy of the MERGE statement.

      This is not allowed.

      table-name
      The name of the target table of the MERGE statement.
      trigger-name
      The name of the trigger that attempted to modify the target table.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Change the MERGE statement to remove the operation that causes the constraint or trigger to activate, or alter the table that has the constraint or trigger to remove the reference to the target table.

      SQLSTATE: 27000
© Copyright IBM Corp.