HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

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 */
     /*    NATIVE-3000                                            */

     CREATE TEMPSPACE TEMPSPACE1
        WITH MAXFILEPAGES = 1000,
        LOCATION = TEMP.SOMEACCT;

     COMMIT WORK;
     ~

MPE/iX 5.5 Documentation