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


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 -723
   
 
  • Causa
    • AN ERROR OCCURRED IN A TRIGGERED SQL STATEMENT IN TRIGGER trigger-name, SECTION NUMBER section-number.
      INFORMATION RETURNED: SQLCODE sqlerror, SQLSTATE sqlstate, AND MESSAGE TOKENS token-list

      During execution of an UPDATE, INSERT, or DELETE statement, a trigger was activated.
      One of the triggered SQL statements received an SQL error condition.

      trigger-name
      The trigger that was activated when the error occurred.
      section-number
      The section number associated with the failing triggered SQL statement.
      For triggers that contain a WHEN clause, the WHEN clause is section number one.
      The triggered SQL statements are numbered sequentially, beginning with section number two.
      This is true for triggers with or without a WHEN clause.
      sqlcode
      The SQLCODE received by the activated trigger.
      sqlstate
      The corresponding SQLSTATE for the SQLCODE received by the activated trigger.
      token-list
      The list of tokens from the original SQL error.
      This list might be truncated.
  • Ação do sistema
    • The trigger and the original INSERT, UPDATE, or DELETE statement cannot be processed.
      The triggering table is unchanged.
  • Resposta ao Desenvolvedor
    • Contact your Database Administrator to determine why the trigger named in the message received the error.
  • Resposta ao Administrador:
    • Use the trigger name and section number to determine the failing SQL statement.
      If the trigger definition is available, use the section number to determine the failing statement.
      Alternatively, the failing statement can be retrieved from the SYSIBM.SYSPACKSTMT catalog table: 
      
                    SELECT TEXT, 
                           SEQNO 
                    FROM   SYSIBM.SYSPACKSTMT 
                    WHERE  COLLID = 'schema-name' 
                    AND    NAME = 'trigger-name' 
                    AND    SECTNO = section-number 
                    ORDER  BY SEQNO
      Refer to the explanation of the reported SQLCODE. Follow the action suggested by that SQLCODE.

      SQLSTATE: SQLSTATE: 09000
© Copyright IBM Corp.