ALLBASE/SQL Reference Manual (36216-90216)

206 Chapter6

Names

DBEFile and Log File Identiﬁers

DBEFiles and log ﬁles have logical names which conform to the rules for ALLBASE/SQL

basic names. DBEFile and log ﬁle names are stored in the system catalog.

In addition to logical names, the physical DBEFiles and log ﬁles are referred to in the SQL

syntax by system ﬁle names. If the group and account are not given, ALLBASE/SQL

assumes the name speciﬁed is in the current group and account. System ﬁle names are

always enclosed in single quotation marks in SQL commands.

TempSpace Names

A TempSpace name is a logical name for the area where temporary ﬁles are stored by

ALLBASE/SQL. This name conforms to the rules for ALLBASE/SQL basic names.

TempSpace names are stored in the system catalog.

Special Names

ALLBASE/SQL has several names with special meaning. You should not create objects

with these names as owner:

• TEMP— Modules owned by TEMP are deleted when the transaction in which they are

created terminates.

• CATALOG— This name is the owner of the catalog views.

• SYSTEM— This name designates the owner of the system views.

• HPRDBSS and STOREDSECT— These names designate the owners of the system

tables. STOREDSECT owns the tables used to store compiled sections and views;

HPRDBSS owns all other system tables.

• PUBLIC— This name refers to

all

users and authorization groups who have been

granted CONNECT authority.

• HPODBSS— This name is reserved.

• SEMIPERM— This name is the owner of all semi-permanent sections.