Basic names and DBEUserIDs are considered simple
names. In some cases, simple names are combined to form
a compound identifier, which consists of
an owner name combined with one or more basic names, with periods
(.) between them.
Often you can abbreviate a compound identifier by omitting
one of its parts. If you do this, a default value is automatically
used in place of the missing part. For example, you can omit the
owner name (and the period) when you refer to tables you own; ALLBASE/SQL generates
the owner name by using your login name.
A complete compound identifier, including all of its parts,
is called a fully qualified name. The following
are compound identifiers:
Authorization group
identifier—[Owner.]GroupName
Column identifier— [ [Owner.]TableName.]ColumnName
Constraint identifier— [Owner.]ConstraintName
Index identifier— [Owner.]IndexName
Module identifier—[Owner.]ModuleName
Procedure identifier— [Owner.]ProcedureName
Rule identifier—[Owner.]RuleName
Section identifier— [Owner.]ModuleName(SectionNumber)
Table identifier— [Owner.]TableName
View identifier— [Owner.]ViewName
Different owners can have modules, tables, or views by the
same name; the fully qualified name of these objects must be unique
in the DBEnvironment. Group names, however, must be unique in the
DBEnvironment.