Naming Conventions for Applications and Databases

When naming applications and databases, follow these rules:

  • Use no more than 8 bytes when naming non-Unicode-mode applications and databases.

  • Use no more than 30 characters when naming Unicode-mode applications and databases.

  • Do not use spaces in the name.

  • Do not use the characters listed in the name:

    Table B-1 List of Restricted Characters in Application and Database Names

    Character Description

    *

    asterisk

    []

    brackets

    :

    colon

    ;

    semicolon

    ,

    comma

    =

    equal sign

    >

    greater-than sign

    <

    less-than sign

    .

    period

    +

    plus sign

    ?

    question mark

    "

    double quotation mark

    single quotation mark

    ` back apostrophe

    /

    forward slash

    \

    backslash

    |

    vertical bars

    [TAB]

    tabs

  • For database names, do not use the:

    • String drxxxxxx (not case-sensitive)

    • Reserved word Replay

  • For aggregate storage databases, do not use the following words as application or database names:

    DEFAULT
    LOG
    METADATA
    REPLAY
    TEMP

Application and database names are not case-sensitive. However, on case-sensitive file systems, the application or database name is created exactly as you enter it. Therefore, when creating, renaming, or copying applications and databases on case-sensitive file systems, Essbase ensures that the same application or database name but with different case usage cannot be used. For example, if you create an application name with all uppercase letters (NEWAPP), you cannot then create an application with the same name but with mixed-case letters (Newapp). Also, when manually copying application and database files from one computer to another and then creating an application or database, you must use the same case for the application and database directory names on both computers.