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


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

   
 
  • Causa
    • AFTER TRIGGER trigger-name ATTEMPTED TO MODIFY A ROW IN TABLE table-name THAT WAS MODIFIED BY AN SQL DATA CHANGE STATEMENT WITHIN A FROM CLAUSE.

      An SQL data change statement was specified in the FROM clause where FINAL TABLE was specified, but the underlying target base table of the SQL data change statement has an AFTER trigger defined which modifies the same table.
      This is disallowed.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Avoid using the SQL data change statement within a FROM clause, or change the trigger so that it does not modify the table that is the target of the SQL data change statement.

      SQLSTATE: 560C3
© Copyright IBM Corp.