Chapter 9 Working with Data Models


Synonym checks (PDM)

The following PDM model checks are made on synonyms:

Check Description and Correction
Synonym name and code uniqueness Synonym 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
Synonym name and code maximum length The synonym name and code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects→Synonym 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 the base object A synonym must correspond to a model object. By default, when you create synonyms from the List of Synonyms using the Add a Row tool, they are not attached to any base object.

Manual correction: Select a base object from the synonym property sheet

Automatic correction: Deletes the synonym

 


Copyright (C) 2008. Sybase Inc. All rights reserved.