View Checks (PDM)

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

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.

View code maximum length

The view code length is limited by the maximum length specified for the table code length.

  • Manual correction: Modify the view code length to meet this requirement

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

Existence of permission

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

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

  • Automatic correction: None