Physical Database DDL Statements › Naming Conventions

Naming Conventions

Valid Characters

A physical DDL entity name consists of a combination of:

• Upper case letters (A through Z)
• Digits (0 through 9)
• At sign (@)
• Dollar sign ($)
• Pound sign (#)
• Hyphen (-) or underscore (_), but not both; do not use a hyphen or underscore when naming the following entities:
  • DBNAME
  • DBTABLE
  • DMCL
  • SEGMENT

The first character of an identifier must be a letter, @, $, or #. If you like, you can enclose the identifier in double quotes (").

Qualifying Entity Names

Names for some entities can be qualified by names of other entities. For example, a database buffer can be qualified by the name of the DMCL with which it is associated.

To qualify an entity, specify the qualifier first, followed by a period (.), followed by the name of the entity you are qualifying. For example, the following qualified identifier identifies the EMP_BUFF database buffer associated with DMCL IDMSDMCL:

idmsdmcl.emp_buff

Number of Characters

The following table summarizes how long each entity name can be: