Previous Topic: Define an Informix View TriggerNext Topic: Default Trigger Templates


Define a SAP ASE View Trigger

Use the View Trigger Editor to define the stored procedures that exist for a view in a SAP ASE physical model.

To define a SAP ASE view trigger

  1. Right-click the view for which you want to define a trigger and click Trigger Properties.

    The SAP ASE View Trigger Editor opens.

  2. Select the view trigger in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new view trigger. Use the Enter filter text box to filter a very large list of view triggers to quickly locate the one that you want to define.

    Name

    Displays the view trigger name. You can change the trigger name in this field.

    Insert

    Specifies to execute the view trigger on INSERT.

    Update

    Specifies to execute the view trigger on UPDATE.

    Delete

    Specifies to execute the view trigger on DELETE.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the General tab and define referential integrity constraints.
  4. Click the Code tab to define the code type for the view trigger.
  5. Click the Expanded tab to view expanded code for the view trigger.
  6. (Optional) Click the Comment tab and enter any comments that you want to associate with the view trigger.
  7. (Optional) Click the UDP tab to work with user-defined properties for the view trigger.
  8. (Optional) Click the Notes tab to view history associated with the view trigger and to add or view user notes.
  9. Click Close.

    The view trigger is defined and the SAP ASE View Trigger Editor closes.