SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-84
Syntax Description of CREATE TABLE
partn-file-option
is defined as:
{[RANGE] PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD range-partn-defn [,ADD range-partn-defn]...)]
defines secondary partitions for a range partitioned table.
BY (partitioning-column [,partitioning-column]...)
specifies the partitioning columns. The default is the default partitioning key
created by the STORE BY clause. Partitioning character columns must derive
from the ISO88591 character set. Partitioning columns cannot be floating-point
data columns.
| HASH PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD partn-defn [,ADD partn-defn]...)]}
defines secondary partitions for a hash partitioned table.
BY (partitioning-column [,partitioning-column]...)
specifies the columns that make up the partitioning key. If you do not specify
this clause, the partitioning key is the same as the clustering key of the table.
Partitioning columns cannot be floating-point data columns.
ADD range-partn-defn
defines a single secondary partition and includes the FIRST KEY and a
partn-defn.
FIRST KEY {col-value | (col-value [,col-value]...)}
specifies the beginning of the range for a range partitioned table. The
FIRST KEY clause specifies the lowest values in the partition for columns
stored in ascending order and the highest values in the partition for
columns stored in descending order. These column values are referred to
as the partitioning key.
col-value is a literal that specifies the first value allowed in the
associated partition for that column of the partitioning key. If there are more
storage key columns than col-value items, the first key value for each
remaining key column is the lowest or highest value for the data type of the
column (the lowest value for an ascending column and the highest value
for a descending column). col-value must contain characters only from
the ISO88591 character set.
If the table has a system-generated SYSKEY, its column list cannot consist
only of column SYSKEY. The SYSKEY must be the last column of the