HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE DEFAULTSPACE 

Generates SQL commands necessary to recreate the default DBEFileSet for
section or table space.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> [GEN[ERATE]] DEFAULTSPACE  Schema File Name or '//' to STOP command >>

SchemaFileName 

Parameters 

SchemaFileName          is the name of the schema file where SQLGEN
                        places the generated commands.

Example 

     >> DEFAULTSPACE 

     ALLBASE/SQL Command Generator for Default DBEFileset

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

     Generating command to SET DEFAULT TABLESPACE to DBEFileSet SYSTEM

     Generating command to SET DEFAULT SECTIONSPACE to DBEFileSet PURCHFS
     >>

Schema File Produced 

     SET DEFAULT TABLESPACE TO DBEFILESET SYSTEM
        FOR PUBLIC;

     SET DEFAULT SECTIONSPACE TO DBEFILESET PURCHFS
        FOR PUBLIC;

     COMMIT WORK;

MPE/iX 5.5 Documentation