HP 3000 Manuals

ALLBASE/SQL Reference Manual

DROP DBEFILESET 

The DROP DBEFILESET statement removes the definition of a DBEFileSet from
the system catalog.

Scope 

ISQL or Application Programs

SQL Syntax 

DROP DBEFILESET DBEFileSetName 

Parameters 

DBEFileSetName          is the name of the DBEFileSet to be dropped.

Description 

   *   Before you can drop a DBEFileSet, you must use the REMOVE DBEFile
       statement to remove any DBEFiles associated with the DBEFileSet.

   *   You cannot DROP a default DBEFileSet.  You must first change the
       default to some other DBEFileSet.

   *   DROP also removes any authorities associated with the DBEFileSet.
       (Refer to syntax for the GRANT statement with the ON DBEFILESET
       clause.)

Authorization 

You must have DBA authority to use this statement.

Example 

     CREATE DBEFILE ThisDBEFile WITH PAGES = 4,
                    NAME = 'ThisFile', TYPE = TABLE

     CREATE DBEFILESET Miscellaneous

     ADD DBEFILE ThisDBEFile TO DBEFILESET Miscellaneous

The DBEFile is used to store rows of a new table.  When the table needs
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

     CREATE DBEFILESET OtherDBEFileSet

     ADD DBEFILE ThatDBEFile TO DBEFILESET OtherDBEFileSet

The following statement allows you to use ThisDBEFile to store an index
later, if you need one.

     ALTER DBEFILE ThisDBEFile SET TYPE = MIXED

If, later, all rows are deleted from the table, you can reclaim file
space.

     REMOVE DBEFILE ThisDBEFile FROM DBEFILESET Miscellaneous

     DROP DBEFILE ThisDBEFile

If it is not a default DBEFileSet, you can now drop its definition.

      DROP DBEFILESET Miscellaneous 

MPE/iX 5.5 Documentation