Chapter 9 Working with Data Models
The following PDM model checks are made on views:
| Check | Description and Correction |
|---|---|
| View name and code uniqueness | View 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 |
| View code maximum length | The view code length is limited by the maximum length specified for the table code length.
Manual correction: Modify the view code length to meet this requirement Automatic correction: Truncates the view code length to the maximum length specified in the DBMS definition |
| Existence of permission | Permissions are usage restrictions set on a view for a particular user, group or role.
Manual correction: Define permissions on the view for users, groups and roles Automatic correction: None |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |