Appendix f. naming rules, General naming rules – IBM GC09-2830-00 User Manual

Page 177

Advertising
background image

Appendix F. Naming Rules

Go to the section that describes the naming rules that you require
information on:
v “General Naming Rules”

v “Database, Database Alias, and Catalog Node Name Rules”

v “Object Name Rules” on page 166

v “Username, User ID, Group Name, and Instance Name Rules” on

page 167

v “Password Rules” on page 168

v “DB2SYSTEM Naming Rules” on page 168

v “Workstation Name (nname) Rules” on page 167

General Naming Rules

Unless otherwise specified, all names can include the following characters:
v A through Z

When used in most names, characters A through Z are converted
from lowercase to uppercase.

v 0 through 9
v @, #, $, and _ (underscore)

Unless otherwise specified, all names must begin with one of the following
characters:
v A through Z
v @, #, and $

Do not use SQL reserved words to name tables, views, columns, indexes, or
authorization IDs.

For a list of SQL reserved words, refer to SQL Reference.

Database, Database Alias, and Catalog Node Name Rules

Database names are the identifying names assigned to databases in the
database manager.

© Copyright IBM Corp. 1993, 1999

165

Advertising