|SAS/ACCESS Software for Relational Databases: Reference
DB2 objects include tables,
views, columns, and indexes. Use the following naming conventions for them:
- A name can start with a letter or one of the following
symbols: the dollar sign ($), the number (or pound) sign (#), or the at symbol
- A name can be from 1 to 18 characters long.
- A name can contain the letters A through Z, any
valid letter with an accent (such as a), the digits 0 through 9, the underscore
(_), the dollar sign ($), the number or pound sign (#), or the at symbol (@).
- A name is not case-sensitive (for example, the
table name CUSTOMERS is the same as Customers), but object names are converted
to uppercase when typed. If a name is enclosed in quotes, then the name is
- A name cannot be a DB2 or an SQL reserved word,
such as WHERE or VIEW.
- A name cannot be the same as another DB2 object
that has the same type.
Schema and database names have similar conventions,
except that they are each limited to eight characters. For more information,
see your DB2 SQL reference manual.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.