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


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 -797
   
 
  • Causa
    • ATTEMPT to CREATE TRIGGER trigger-name WITH AN UNSUPPORTED TRIGGERED SQL STATEMENT

      The trigger definition includes an unsupported triggered SQL statement.

      The SQL statements allowed as a triggered SQL statement depend on the type of trigger:
      • A BEFORE trigger can include the following triggered SQL statements:
        • a fullselect or VALUES statement
        • a SET transition-variable statement (not allowed in a BEFORE DELETE trigger)
        • a SIGNAL SQLSTATE statement
        • a CALL statement
      • An AFTER trigger can include the following triggered SQL statements:
        • a fullselect or VALUES statement
        • an INSERT statement
        • a searched UPDATE statement
        • a searched DELETE statement
        • a SIGNAL SQLSTATE statement
        • a CALL statement
  • Ação do sistema
    • The CREATE TRIGGER statement cannot be executed, and the trigger is not created.
  • Resposta ao Desenvolvedor
    • Check the triggered SQL statements in the trigger for any statement that is not listed above and remove it.

      SQLSTATE: 42987
© Copyright IBM Corp.