Procedure Checks (PDM)

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

Check

Description and Correction

Name/Code contains terms not in glossary

[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - None.

Name/Code contains synonyms of glossary terms

[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - Replaces synonyms with their associated glossary terms.

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.

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