Disable Triggers and Constraints

The Disabling Trigger/Constraint Confirmation dialog allows you to selectively enable and disable any triggers or constraints during and after processing.

The Disabling Trigger/Constraint Confirmation dialog is displayed at runtime if you select the Prompt option for Disable Triggers, Disable Constraints, or both, on the General tab for the Insert Request Editor.

Disabling Trigger/Constraint Confirmation dialog
Note: When running the Insert Request from the Command Line, the Monitor keyword governs the display of the Disabling Trigger/Constraint Confirmation dialog. If the display is suppressed (using M-), all triggers and constraints are disabled during processing and enabled after processing.

The Disabling Trigger/Constraint Confirmation dialog is divided, displaying one or more tabs that list tables to be processed in the upper half and tabs in the lower half that list any database triggers and referential integrity constraints for each table.

List of Tables

A tab for each DB Alias lists the tables in the database referenced by the DB Alias. Click a Focus Arrow grid cell to reposition the arrow, or use the up/down arrows on your keyboard. The tabs on the lower half of the dialog list triggers and constraints for the table indicated by the focus Arrow.

Trigger List and Constraint List Tabs

On both the Trigger List or Constraint List tab, you can click a Status During Process or Status After Process grid cell to select Enabled or Disabled status for each table or you can right click a Status During Process or Status After Process grid column to select Enabled or Disabled status for all tables.

For Informix® tables, you can select a status of Enabled, Disabled, With Vio, or No Vio. If you select Enabled, the Informix default for violation tables applies. Alternatively, you can select With Vio to enable the constraint and use a violation table or No Vio to enable the constraint and not use a violation table.