HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

GENERATE PARTITION 

Generates SQL commands necessary to recreate DBEnvironment partitions.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> [GEN[ERATE]] PARTITION  Schema File Name or '//' to STOP command >>

SchemaFileName  PARTITION Name >> PartitionName 

Parameters 

SchemaFileName          is the name of the schema file where SQLGEN
                        places the generated commands.

PartitionName           is the name of the partition to be recreated.

Example 

     >> PARTITION 

     ALLBASE/SQL Command Generator for Partitions

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

     Please enter PARTITION Names. Type @ for all, ? for a list  of
     PARTITION Names, or RETURN to quit.

     PARTITION Name >> CAVENDOR 

     Generating command to CREATE PARTITION CAVENDOR

     PARTITION Name >> Return 

Schema File Produced 

     CREATE PARTITION CAVENDOR
        WITH ID = 12;

     COMMIT WORK;

MPE/iX 5.5 Documentation