HP 3000 Manuals HP 3000 Manuals
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} TO DBEFILESET DBEFileSetName FOR PUBLIC
{TABLESPACE }
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.
Authorization
You must have DBA authority to set a DBEFileSet default.
Example
Set Default DBEFileSet
GRANT SECTIONSPACE ON DBEFILESET SectionDBESet to PUBLIC;
GRANT TABLESPACE ON DBEFILESET TableDBESet to PUBLIC;
SET DEFAULT SECTIONSPACE TO DBEFILESET SectionDBESet FOR PUBLIC;
SET DEFAULT TABLESPACE TO DBEFILESET TableDBESet FOR PUBLIC;