|
|
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.
ISQL or Application Programs
SET DEFAULT {SECTIONSPACE
TABLESPACE } TO DBEFILESET DBEFileSetName FOR PUBLIC
- 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.
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.
You must have DBA authority to set a DBEFileSet default.
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;
|