ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 331
SQL Statements A - D
CREATE DBEFILESET
Authorization
You must have DBA authority to use this statement.
Example
The DBEFile is used to store rows of a new table.
CREATE DBEFILE ThisDBEFile WITH PAGES = 4,
NAME = 'ThisFile', TYPE = TABLE
CREATE DBEFILESET Miscellaneous
ADD DBEFILE ThisDBEFile TO DBEFILESET Miscellaneous
When the table needs a DBEFile to hold an index, one is created as follows:
CREATE DBEFILE ThatDBEFile WITH PAGES = 4,
NAME = 'ThatFile', TYPE = INDEX
ADD DBEFILE ThatDBEFile TO DBEFILESET Miscellaneous
When the index is subsequently dropped, its file space can be assigned to another
DBEFileSet.
REMOVE DBEFILE ThatDBEFile
FROM DBEFILESET Miscellaneous
ADD DBEFILE ThatDBEFile
TO DBEFILESET SomethingElse
ALTER DBEFILE ThisDBEFile SET TYPE = MIXED
Now you can use this DBEFile to store an index later if you need one.
All rows are later deleted from the table, so you can reclaim file space.
REMOVE DBEFILE ThisDBEFile
FROM DBEFILESET Miscellaneous
DROP DBEFILE ThisDBEFile
The DBEFileSet definition can now be dropped.
DROP DBEFILESET Miscellaneous
CREATE DBEFILE NewDBEFile
ADD DBEFILE NewDBEFile
TO DBEFILESET SYSTEM