SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-83
Syntax Description of CREATE TABLE
•
The name must be exactly eight characters long.
file-name
is a Guardian file name. file-name names must be eight characters in length
and must end with the digits “00” (zero zero.)
Any Guardian file name you specify must match the designated schema
subvolume name for the schema in which the object is being created.
Otherwise, NonStop SQL/MX returns an error.
partition-name
is an SQL identifier for a partition.
partn-file-option is:
{[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.
range-partn-defn is:
FIRST KEY {col-value | (col-value [,col-value]...)}
partn-defn
specifies the beginning of the range for a range partitioned table. The
FIRST KEY clause specifies the lowest values in the partition for columns