SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-108
Syntax Description of CREATE TABLE

The name must begin with the letters ZSD, followed by a letter, not a digit
(for example, ZSDa, not ZSD2).

The name must be exactly eight characters long.

The subvolume 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.
file-name
is a Guardian file name. file-name must be eight characters in length and
must end with the digits 00 (zero zero).
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: