Database Package Checks (PDM)

PowerDesigner provides default model checks to verify the validity of database packages.

Check	Description and Correction
Database package name and code uniqueness	Database package 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
Database package name and code maximum length	The database package name and code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > DB Package category) and in the naming conventions of the model options. Manual correction: Modify the name/code length to meet this requirement Automatic correction: Truncates the name/code length to the maximum length specified in the DBMS definition
Existence of package `subobject`	A database package must have a number of subobjects defined in order to be correctly modeled. Manual correction: Create one or more of the relevant object on the appropriate tab of the database package property sheet: Procedures (or use existing stored procedures and duplicate them in the database package) Cursors Variables Types Exceptions Automatic correction: None

Check

Description and Correction

Database package name and code uniqueness

Database package 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

Database package name and code maximum length

The database package name and code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > DB Package category) and in the naming conventions of the model options.

Manual correction: Modify the name/code length to meet this requirement

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

Existence of package subobject

A database package must have a number of subobjects defined in order to be correctly modeled.

Manual correction: Create one or more of the relevant object on the appropriate tab of the database package property sheet:

Procedures (or use existing stored procedures and duplicate them in the database package)
Cursors
Variables
Types
Exceptions

Automatic correction: None