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


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

   
 
  • Causa
    • OLD OR NEW CORRELATION NAMES ARE NOT ALLOWED IN A TRIGGER DEFINED WITH THE FOR EACH STATEMENT CLAUSE.
      OLD_TABLE OR NEW_TABLE NAMES ARE NOT ALLOWED IN A TRIGGER WITH THE BEFORE CLAUSE.

      The trigger, as defined, includes a REFERENCING clause with one of the following invalid combinations:
      • OLD or NEW correlation names specified (or both) and the FOR EACH STATEMENT clause.
      • NEW_TABLE or OLD_TABLE correlation names specified (or both) and the BEFORE clause.
  • Ação do sistema
    • The statement cannot be executed.
      The trigger was not defined.
  • Resposta ao Desenvolvedor
    • Remove invalid correlation names or change the trigger granularity to FOR EACH ROW.

      SQLSTATE: 42899

© Copyright IBM Corp.