Chapter 9 Working with Data Models


Database package cursor checks (PDM)

The following PDM model checks are made on 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

 


Copyright (C) 2008. Sybase Inc. All rights reserved.