Results of Defining Structures Using SQL Statements › CREATE TRIGGER Statement

CREATE TRIGGER Statement

CREATE TRIGGER

Creates a trigger. The following are the significant TRIGGER entity-occurrence attributes defined:

• ACTION-LEVEL= In conjunction with the Trigger Action Time switches, indicates whether the trigger is to be invoked for each row (R) processed or for each SQL statement (S).
• AFTER-DELETE=

  AFTER-INSERT=

  AFTER-UPDATE=

  Indicates with Y or N whether the trigger should be invoked after the action has taken place on the table. One or more of these switches and/or the BEFORE-x switches must be set to Y for the trigger to be valid.

• AUTHID= This is the authorization identifier (schema) in effect when the trigger was created.
• BEFORE-DELETE=

  BEFORE-INSERT=

  BEFORE-UPDATE=

  Indicates with Y or N whether the trigger should be invoked before the action has taken place on the table. One or more of these switches and/or the AFTER-x switches must be set to Y for the trigger to be valid.

• ENTITY-NAME= This is an internally generated unique name consisting of the schema (the AUTHID), followed by a hyphen, followed by the SQLNAME value.
• FIPS= Indicates if the procedure is valid in FIPS processing. Y indicates yes, N indicates no, and S indicates no because of syntax.
• NEW-ROW-CORR-NAME=
  OLD-ROW-CORR-NAME=
  The alternative names for the before and after row images.
• NEW-TABLE-ALIAS=
  OLD-TABLE-ALIAS=
  The alternative names for the before and after table images.
• SQLNAME= The name of the trigger specified in the CREATE TRIGGER statement.
• SQL-TIMESTAMP= The ANSI Standard specifies that triggers are to be invoked in the order they are created, with the oldest being invoked first. The SQL timestamp ensures that triggers are invoked in that order.
• TRIGGER-VALID= When a change is made to a table referenced by a trigger and that change can affect the ability of the trigger to function correctly, this attribute is set to N. Otherwise, it is set to Y. This attribute is also set to N if there is a recognized change to a procedure called by the trigger.
• UPDATE-TRIGGER= This attribute indicates, in conjunction with the BEFORE-UPDATE and AFTER-UPDATE attributes, whether the trigger is invoked only when certain columns are updated (EXPLICIT) or when any column in the table is updated (IMPLICIT).