GENERATE DBEFILES

Generates SQL commands to recreate one or more DBEFileSets and associated DBEFiles.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GEN[ERATE]]DBEFILE[S] Schema File Name or '//' to STOP command >> SchemaFileName DBEFileSet Name >> DBEFileSetName

Parameters

SchemaFileName: is the name of the schema file where SQLGEN places the generated commands.
DBEFileSetName: is the name of the DBEFileSet for which you wish to GENERATE commands.

Description

GENERATE DBEFILES builds commands to recreate DBEFileSets. It then builds commands to recreate DBEFiles and to associate these DBEFiles with their respective DBEFileSets.
When @ is entered, commands for all DBEFileSets and DBEFiles are generated, including DBEFiles which have not been added to a DBEFileSet.
When generating the SYSTEM DBEFileSet, commands to CREATE DBEFILESET and build DBEFILE0 are not generated since these commands are issued by START DBE NEW when the DBEnvironment is recreated.

Example

   >> gen dbefile

   ALLBASE/SQL Command Generator for DBEFiles



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



   Please enter DBEFileSet Names. Type @ for all, ? for a list of

   DBEFileSet names, or RETURN to quit.



   DBEFileSet Name >> WarehFS



   Generating command to CREATE DBEFILESET WAREHFS



   Generating command(s) for DBEFILE WAREHDATAF1

   Generating command(s) for DBEFILE WAREHINDXF1



   DBEFileSet Name >>   Return 

   >>

Schema File Produced



   CREATE DBEFILESET WAREHFS;



   CREATE DBEFILE WAREHDATAF1

      WITH PAGES = 50, NAME = 'WAREHDF1',

      TYPE = TABLE;



   ADD DBEFILE WAREHDATAF1 TO DBEFILESET WAREHFS;



   CREATE DBEFILE WAREHINDXF1

      WITH PAGES = 50, NAME = 'WAREHXF1',

      TYPE = INDEX;



   ADD DBEFILE WAREHINDXF1 TO DBEFILESET WAREHFS;



   COMMIT WORK;