HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix G SQLGEN

GENERATE DBE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Generates the SQL command to START DBE NEW for a DBEnvironment.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GENERATEDBE] Schema File Name or '//' to STOP command >> SchemaFileName

Parameters

SchemaFileName

is the name of the schema file where SQLGEN places the generated command.

Description

  • The GENERATE DBE command builds the START DBE NEW command necessary to START the new DBEnvironment. Note that since the logical log DBEFile names are not stored in the system catalog, SQLGEN cannot know what these names are. Consequently, the names DBELOG1 and, if dual logging is in effect, DBELOG2 are used.

  • No COMMIT WORK is generated for this command.

Example

 

   >> gen dbe



   ALLBASE/SQL Command Generator for DBE



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



   Generating command to START DBE PARTSDBE



   >>


Schema File Produced

 

     START DBE 'PARTSDBE' MULTI NEW

      DUAL LOG,

      BUFFER = (100,  24),

      TRANSACTION = 5,

      DBEFILE0 DBEFILE PARTSDBE0

         WITH PAGES = 150,

         NAME = 'PARTSF0',

      LOG DBEFILE DBELOG1 AND DBELOG2

         WITH PAGES = 256,

         NAME = 'PARTSLG1'

            AND 'PARTSLG2';


Feedback to webmaster