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


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 -696
   
 
  • Causa
    • THE DEFINITION OF TRIGGER trigger-name INCLUDES AN INVALID USE OF CORRELATION NAME OR TRANSITION TABLE NAME name.
      REASON CODE=reason-code

      The trigger definition included an invalid use of name

      trigger-name
      The trigger that encountered the error
      name
      The transition variable correlation name or transition table name
      reason-code
      A reason-code indicating the specific problem as follows:
      1. NEW correlation name and NEW_TABLE name are not allowed in a DELETE trigger.
      2. OLD correlation name and OLD_TABLE name are not allowed in an INSERT trigger.
      3. OLD_TABLE name and NEW_TABLE name are not allowed in a BEFORE trigger.
  • Ação do sistema
    • The statement cannot be executed.
      The trigger was not created.
  • Resposta ao Desenvolvedor
    • Remove the invalid correlation name or transition table name along with the preceding keyword.

      SQLSTATE: 42898

© Copyright IBM Corp.