Chapter 9 Working with PDMs
The following PDM model checks are made on 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 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 procedure | A database package is an encapsulated collection of related procedures. It should contain at least one procedure.
Manual correction: Create one or several procedures in the database package or use existing stored procedures and duplicate them in the database package Automatic correction: None |
| Existence of package cursor | This check is to suggest that a database package can contain cursors to define a work area and access its stored information.
Manual correction: Create one or several cursors in the Cursors tab of the database package property sheet Automatic correction: None |
| Existence of package variable | This check is to suggest that a database package can contain variables to capture or provide a value when one is needed.
Manual correction: Create one or several variables in the Variables tab of the database package property sheet Automatic correction: None |
| Existence of package type | This check is to suggest that a database package can contain user-defined data types called types.
Manual correction: Create one or several types in the Types tab of the database package property sheet Automatic correction: None |
| Existence of package exception | This check is to suggest that a database package can contain exceptions to handle internal and user-defined error conditions.
Manual correction: Create one or several exceptions in the Exceptions tab of the database package property sheet Automatic correction: None |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |