SYSTEM.SPACEDEFAULT contains the default
TABLESPACE and SECTIONSPACE DBEFileSets for PUBLIC.
Initially SYSTEM.SPACEDEFAULT contains two rows, one having the column values
PUBLIC, SYSTEM, 1 and the other having the column values PUBLIC, SYSTEM, 2.
Thus SYSTEM is the default DBEFileSet for table, long column, and
section data for PUBLIC.
ALLBASE/SQL accesses SYSTEM.SPACEDEFAULT whenever a table, long column,
rule, check constraint, procedure, or section
(generated by a PREPARE, DECLARE CURSOR, or CREATE VIEW statement)
is created without the IN DBEFileSetName clause.
Table 8-33 System.Spacedefault
| Column Name | Type | Length | Description |
|---|
| USERID | CHAR | 20 | Authorized DBEUserID or authorization group |
| DBEFILESET | CHAR | 20 | Name of a DBEFileSet |
| SPACETYPE | SMALLINT | 2 | Type of default DBEFileSet:
1 (SECTIONSPACE)
2 (TABLESPACE)
|
EXAMPLE |
 |
SELECT * FROM System.Spacedefault;
--------------------+--------------------+---------
USERID |DBEFILESET |SPACETYPE
--------------------+--------------------+---------
PUBLIC |SYSTEM | 1
PUBLIC |SYSTEM | 2
--------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
