ALLBASE/SQL Reference Manual (36216-90216)

524 Chapter12
SQL Statements S - Z
SET DEFAULT DBEFILESET
SET DEFAULT DBEFILESET
The SET DEFAULT statement is used to set the default DBEFileSet for stored sections or for
tables and long columns associated with a DBEnvironment. Before initial issue of this
statement, the SYSTEM DBEFileSet is the default.
Scope
ISQL or Application Programs
SQL Syntax
SET DEFAULT {SECTIONSPACE
TABLESPACE } TO DBEFILESET DBEFileSetName FOR PUBLIC
Parameters
SECTIONSPACE sets the default DBEFileSet for stored sections.
TABLESPACE sets the default DBEFileSet for tables and long columns.
DBEFileSetName designates the DBEFileSet for which the default is to be set.
Description
• PUBLIC must have the appropriate authority on the specified DBEFileSet. (Refer to
syntax for the GRANT statement.)
• You can grant SECTIONSPACE or TABLESPACE authority for a DBEFileSet to a
specific user, thereby giving that user the ability to explicitly put sections, tables, or
long columns in the granted DBEFileSet when they are created. However, you cannot
set a default DBEFileSet for a specific user.
• If a section is created without the IN
DBEFileSet clause, or if the owner of the section
does not have SECTIONSPACE authority for the DBEFileSet specified when the
section was created, the section is stored in the default SECTIONSPACE DBEFileSet
for PUBLIC. This applies to rules, stored procedures, check constraints, views, and
prepared or preprocessed statements and cursors, all of which have sections associated
with them.
• If a table is created without the IN
DBEFileSet clause, or if the owner of the table does
not have TABLESPACE authority for the DBEFileSet specified when the table was
created, the table is placed in the default TABLESPACE DBEFileSet for PUBLIC.
• If a long column is created without the IN
DBEFileSet clause, it is placed in the same
DBEFileSet as the table unless the owner of the table does not have TABLESPACE
authority for the DBEFileSet the table resides in. In this case, the long column is placed
in the default TABLESPACE DBEFileSet for PUBLIC.