Trigger and DBMS Trigger Checks (PDM)

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

Check	Description and Correction
Name/Code uniqueness	Object names must be unique in the namespace. Manual correction - Modify the duplicate name or code. Automatic correction - Appends a number to the duplicate name or code.
Trigger code maximum 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
Invalid event	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