Chapter Contents

SAS/ACCESS Software for Relational Databases: Reference

DB2 Naming Conventions

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.

Chapter Contents
Previous
Next
Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.