Database Package Cursor Checks (PDM)

PowerDesigner provides default model checks to verify the validity of package cursors.

Check

Description and Correction

Package cursor name and code uniqueness

Database package cursor names and codes must be unique in the database package.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Package cursor definition empty

A package cursor must have a definition.

Manual correction: Create the cursor definition in the Definition tab of the cursor property sheet

Automatic correction: None

Check for undefined return types

You should define a return data type for a cursor.

Manual correction: Select a return data type in the cursor property sheet

Automatic correction: None

Existence of parameter

A cursor must contain parameters for input values.

Manual correction: Create one or several parameters in the Parameters tab of the cursor property sheet

Automatic correction: None