Chapter 9 Working with Data Models
The following PDM model checks are made on package procedures:
| Check | Description and Correction |
|---|---|
| Package procedure name and code uniqueness | Database package procedure 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 procedure definition empty | A package procedure must have a definition.
Manual correction: Create the package procedure definition in the Definition tab of the package procedure property sheet Automatic correction: None |
| Existence of parameter | A package procedure must contain parameters for input and output values.
Manual correction: Create one or several parameters in the Parameters tab of the package procedure property sheet Automatic correction: None |
| Check for undefined return types | If the package procedure is a function, you should define a return data type for the function.
Manual correction: Select a return data type in the Return Data Type list Automatic correction: None |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |