|SAS/ACCESS Software for Relational Databases: Reference
DB2 objects that can be named include tables, views, columns,
and indexes. Use the following DB2 naming conventions:
- A name must start with a letter. If the name is
in quotes, it can start with and contain any character. Depending on how your
string delimiter is set, quoted strings can contain quotes such as "O'Malley".
- The following objects can have names from 1 to
18 characters long: a column, cursor, index, table, view, alias, synonym,
collection ID, statement name, or correlation name.
The following objects can have names from 1 to 8 characters
long: authorization ID, referential constraint, database, table space, storage
group, package, or plan.
A location name can be 1 to 16 characters long.
- A name can contain the letters A through Z, the
digits 0 through 9, and national characters (#, $, or @).
- A name is not case-sensitive. For example, CUSTOMER
is the same as customer. However, if the name of the object is in quotes,
it is case-sensitive.
- The name cannot be a DB2 reserved word.
- A name cannot be the same as another DB2 object.
For example, each column name within the same table must be unique.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.