Trigger and DBMS Trigger Checks (PDM)

The following PDM model checks are made on 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


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com