HP 3000 Manuals

ALLBASE/SQL Reference Manual

DROP TEMPSPACE 

The DROP TEMPSPACE statement removes the definition of a temporary
storage space (TempSpace) from the system catalog.

Scope 

ISQL or Application Programs

SQL Syntax 

DROP TEMPSPACE TempSpaceName 

Parameters 

TempSpaceName           is the name of the TempSpace to be dropped.

Description 

   *   If a TempSpace is dropped while temporary files currently exist
       under the path name it specifies, those files remain until the
       sort using them completes.  However, no further temporary files
       are created in that TempSpace.

   *   If a TempSpace is being used by another user when the DROP
       TEMPSPACE statement is issued, then the DROP statement is blocked
       until the TempSpace usage is finished.

Authorization 

You must have DBA authority to use this statement.

Example 

TempSpace temporary files are created in SomeGrp.SomeAcct when SQL
statements require sorting.

     CREATE TEMPSPACE ThisTempSpace WITH MAXFILEPAGES = 360,
                      LOCATION = 'SomeGrp.SomeAcct'
      DROP TEMPSPACE ThisTempSpace 

TempSpace temporary files will no longer be available in SomeGrp.SomeAcct
but will be allocated in the current group and account as needed.

MPE/iX 5.5 Documentation