Chapter 9 Working with Data Models
The following PDM model checks are made on references:
| Check | Description and Correction |
|---|---|
| Reference name and code uniqueness | Reference 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 |
| Reflexive and mandatory reference | A reflexive reference exists should not have a mandatory parent which could lead to inconsistent joins.
Manual correction: Correct the reference by clearing the Mandatory parent check box Automatic correction: None |
| Existence of reference join | A reference must have at least one reference join.
Manual correction: Create a reference join for the reference or delete the reference Automatic correction: Deletes reference without join |
| Reference code maximum length | The reference code length is limited by the maximum length specified in the DBMS definition (MaxConstLen entry, in the Object→Reference category) or in the naming conventions of the model options.
Manual correction: Modify the reference code length to meet this requirement Automatic correction: Truncates the reference code length to the maximum length specified in the DBMS definition |
| Incomplete join | Joins must be complete.
Manual correction: Select a foreign key column or activate the primary key column migration Automatic correction: None |
| Join order | The join order must be the same as the key column order for some DBMS.
Manual correction: If required, change the join order to reflect the key column order Automatic correction: The join order is changed to match the key column order During a reference check, the following object controls are made. |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |