HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE DBE 

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

Scope 

SQLGEN Only

SQLGEN Syntax 

>> [GEN[ERATE]]DBE  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';

MPE/iX 5.5 Documentation