Chapter 5 Managing Models
Name and code format encompasses constraints on length, character case and type for the name and the code of objects.
By default, PowerDesigner displays object names, you can modify this option and choose to display the code of objects.
You can set name and code format for:
From the Model Options dialog box, you can define the following options for names and codes:
Option | Description |
---|---|
Display Name | Displays the names of objects in the interface |
Display Code | Displays the codes of objects in the interface |
Enable name/code conversions | Enables or disables the use of conversion scripts and conversion tables to generate a code from a name or a name from a code. For more information, see the "Defining name/code conversion" section |
Naming Template | Allows you to use a template for name and code format for several types of objects within a model |
Maximum Length | Maximum number of characters. In a PDM, this maximum number of characters can come from the Registry (if you defined a Maximum length and clicked the Set As Default button) or from the DBMS definition file. If a maximum length is declared in both the Registry and the DBMS, PowerDesigner uses the length with higher constraint. For example, in the case where the Registry = 128 and the DBMS = 30, PowerDesigner uses 30 characters for maximum length |
Character Case | Indicates authorized character cases: Uppercase, Lowercase, and Mixed Case |
Valid Characters | List of authorized characters, you can type ranges of valid characters |
All Valid | Accept all characters |
Invalid Characters | List of unauthorized characters. You can use this box to type exceptions to the ranges of valid characters |
No Accents | Removes accents from accented characters |
Default Character | Character used to replace the invalid characters in the name or code |
When you specify valid characters you define which characters will be accepted and then, you indicate in the invalid character box, which characters will be considered as invalid among those.
The following syntax applies to valid and invalid characters.
Character set | Syntax | Example |
---|---|---|
Interval of characters | Characters in single quotation marks separated by a dash |
'a'-'z' 'a'-'z', 'A'-'Z', '0'-'9' |
Single character and character string | Character in quotation marks |
"a", "xyz" |
PowerDesigner allows the following default valid characters for the codes format:
'a'-'z','A'-'Z','0'-'9',"_"
PowerDesigner defines the following default invalid characters for the names format:
"+-*/\.,!:;"
Copyright (C) 2005. Sybase Inc. All rights reserved. |