GENERATE DBEFILES [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
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;
MPE/iX 5.5 Documentation