Available Naming Conventions

Naming Conventions › Naming Database Information Entities › Available Naming Conventions

Available Naming Conventions

Database elements can be established using approved names from the glossary and can be further defined with synonyms. Element names should have a maximum of 25 characters. The following example lists an element and three synonyms:
```
EMPLOYEE-CODE
DB-REC-EMPLOYEE-CODE
MAP-EMPLOYEE-CODE
WORK-EMPLOYEE-CODE
```
Database Records can be composed of approved, usable names (for example, EMPLOYEE). Records can be given greater flexibility with the addition of suffixes. The following example lists employee records with identifying suffixes:
```
EMPLOYEE-0600
EMPLOYEE-2500
EMPLOYEE-6359
```
SQL: Hyphens are not valid in SQL identifiers referenced in statement syntax. Therefore, SQL entities may not be named using hyphens but may be named using underscores. Hyphens are valid in host variables referenced in SQL statement syntax.

For more information, refer to CA IDMS SQL Programming Guide.

In CA ADS process source, as well as in COBOL, CA Culprit, and map source, the elements can be referenced by the element name plus the suffix, as follows:
```
EMPLOYEE-CODE-6359
```
Map work records are composed of the map name followed by the suffix -MAP-RECORD, as in the following example:
```
CEMMILIS-MAP-RECORD
```
Elements in the map record utilize the prefix MAP- and the element name, as follows:
```
MAP-OFFICE-CODE
```
If the map needs more than one work record, a number is added to the word MAP, as follows:
```
CEMMILIS-MAP2-RECORD (the second map record)
MAP2-OFFICE CODE (a record element from the second record)
```
Dialog work records are composed of the dialog name followed by the suffix -WORK-RECORD as in the following example:
```
CEMDULIS-WORK-RECORD
```
Elements in the dialog work record utilize the prefix WORK- and the element name, as follows:
```
WORK-OFFICE-CODE
```
If the dialog needs more than one work record, a number is added to the word WORK, as follows:
```
CEMDILIS-WORK2-RECORD (the second dialog work record)
WORK2-OFFICE CODE (a record element from the second record)
```
Set names are established by concatenating an abbreviation of the owner record (a seven-character maximum) with that of the member record (a six-character maximum), as follows:
```
EMPL-SKILL
```