ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 481
SQL Statements E - R
REMOVE DBEFILE
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 SYSTEM
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