GENERATE TEMPSPACES

Generates SQL commands to recreate one or more tempspaces in a DBEnvironment.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GEN[ERATE]]TEMPSPACE[S] Schema File Name or '//' to STOP command >> SchemaFileName TEMPSPACE Name >> TempSpaceName

Parameters

SchemaFileName: is the name of the schema file where SQLGEN places generated commands.
TempSpaceName: is the name of the tempspace you wish to generate.

Description

GENERATE TEMPSPACES builds CREATE TEMPSPACE commands to recreate one or more temporary spaces in the DBEnvironment.

Example



   >> generate tempspace



   ALLBASE/SQL Command Generator for Temp Space



   Schema File Name or '//' to STOP command >> temps



   Please enter TEMPSPACE Names.  Type @ for all, ? for a list of

   TEMPSPACE Names, or RETURN to quit.



   TEMPSPACE Name >> @



   Generating command to CREATE TEMPSPACE TEMPSPACE1



   >>

Schema File Produced



   /* This file was created with a user language environment of */

   /*    n-computer                                             */



   CREATE TEMPSPACE TEMPSPACE1

      WITH MAXFILEPAGES = 1000,

      LOCATION = '/tmp';



   COMMIT WORK;

   ~