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.

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;