HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX 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

>> [GENERATE] 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