HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Appendix G SQLGEN

GENERATE DEFAULTSPACE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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;
Feedback to webmaster