Procedure Checks (PDM)

PowerDesigner provides default model checks to verify the validity of procedures.

Check

Description and Correction

Procedure name and code uniqueness

Procedure 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

Procedure code maximum length

The procedure code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > Procedure category).

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

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

Procedure definition body empty

A procedure definition should have a body to specify its functionality.

Manual correction: Specify a procedure body from the Definition tab of the procedure property sheet

Automatic correction: None

Existence of permission

Permissions are usage restrictions set on a procedure for a particular user, group or role.

Manual correction: Define permissions on the procedure for users, groups and roles

Automatic correction: None