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

GENERATE PARTITION

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Generates SQL commands necessary to recreate DBEnvironment partitions.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GENERATE] 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;


Feedback to webmaster