Filter
Top Products
Using delimited identifiers, it is possible to create an object that
violates these naming rules; however, subsequent use of the object
could result in errors.
For example, if you create a column with a + or − sign included in
the name and you subsequently use that column in an index, you
will experience problems when you attempt to reorganize the table.
To avoid potential problems with the use and operation of your
database, do not violate these rules.
Username, User ID, Group Name, and Instance Name Rules
Usernames or User IDs are the identifiers assigned to individual users. When
naming users, groups, or instances, see “General Naming Rules” on page 165.
In addition, the name you specify:
v Can contain 1 to 8 characters
v Cannot be any of the following:
– USERS
– ADMINS
– GUESTS
– PUBLIC
– LOCAL
v Cannot begin with:
– IBM
– SQL
– SYS
v Cannot include accented characters
v In general, when naming users, groups, or instances:
OS/2 Use uppercase names.
Windows 32-bit operating systems
Use any case.
Workstation Name (nname) Rules
A workstation name specifies the NetBIOS name for a database server or client
that resides on the local workstation. This name is stored in the database
manager configuration file. The workstation name is known as the workstation
nname. When naming workstations, see “General Naming Rules” on page 165.
In addition, the name you specify:
Appendix F. Naming Rules 167