ALLBASE/SQL Reference Manual (36216-90216)

Chapter 6 203

Names

Native Language Object Names

All the object names in a DBEnvironment can be represented in the DBEnvironment

language or in NATIVE 3000. The following rules for object names are the same as for

ASCII:

• The length of an object name is speciﬁed as a number of bytes. Note that this would

mean a maximum of 20 characters for a table name in English and 10 in Chinese,

because Chinese is represented in a two-byte character set.

• Table and view names can be qualiﬁed by preﬁxing the owner name followed by a

period ('.') The period serves as the delimiter and is thus a part of the syntax of SQL. It

cannot be represented by a native language delimiter but must be ASCII.

DBEUserIDs

A DBEUserID is made up of a user’s MPE XL user and account names connected with the

@ symbol. An example is WOLFGANG@DBMS, where Wolfgang is the user name, and

DBMS is the account name.

When a DBEnvironment is conﬁgured, ALLBASE/SQL grants DBA authority to the

DBEUserID of the DBECreator. You cannot revoke DBA authority from the DBECreator.

Owner Names

Owner names can be one of the following:

• DBEUserID

• Group name

• Class name