IBM GC09-2830-00 manual Object Name Rules

Database alias names are synonyms given to remote databases. Database aliases must be unique within the System Database Directory in which all aliases are stored.

When naming a database or database alias, see ªGeneral Naming Rulesº on page 165.

In addition, the name you specify can only contain 1 to 8 characters.

To avoid potential problems, do not use the special characters @, #, and $ in a database name if you intend to have a client remotely connect to a host database. Also, because these characters are not common to all keyboards, do not use them if you plan to use the database in another country.

On Windows NT systems, ensure that no instance name is the same as a service name.

Object Name Rules

Database objects include:

vTables

vViews

vColumns

vIndexes

vUser-de®ned functions (UDFs)

vUser-de®ned types (UDTs)

vTriggers

vAliases

vTable spaces

vSchemas

When naming database objects, see ªGeneral Naming Rulesº on page 165.

In addition, the name you specify:

vCan contain 1 to 18 characters except for the following:

±Table names (including view names, summary table names, alias names, and correlation names), which can contain up to 128 characters; and

±column names, which can contain up to 30 characters

vCannot be any of the SQL reserved words that are listed in the SQL Reference.

166Quick Beginnings