Chapter 9 Working with Data Models
The following PDM model checks are made on procedures:
| Check | Description and Correction |
|---|---|
| Procedure name and code uniqueness | Procedure 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 |
| Procedure code maximum length | The procedure code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects→Procedure category).
Manual correction: Modify the procedure code length to meet this requirement Automatic correction: Truncates the procedure code length to the maximum length specified in the DBMS definition |
| Procedure definition body empty | A procedure definition should have a body to specify its functionality.
Manual correction: Specify a procedure body from the Definition tab of the procedure property sheet Automatic correction: None |
| Existence of permission | Permissions are usage restrictions set on a procedure for a particular user, group or role.
Manual correction: Define permissions on the procedure for users, groups and roles Automatic correction: None |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |