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

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