Trigger and DBMS Trigger Checks (PDM)

PowerDesigner provides default model checks to verify the validity of triggers and DBMS triggers.

Check

Description and Correction

Trigger name and code uniqueness

Trigger names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Trigger code length

The trigger code length is limited by the maximum length specified in the DBMS definition (MaxLen).

Manual correction: Modify the trigger code length to meet this requirement

Automatic correction: Truncates the trigger code length to the maximum length specified in the DBMS definition

Trigger event check

The event specified in the DBMS trigger definition must be available in its chosen scope.

Manual correction: Modify the trigger code to reference an event in the chosen scope.

Automatic correction: None