|
» |
|
|
|
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;
|
|