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