SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-87
Syntax Description of CREATE TABLE
If you do not specify a LOCATION clause and your system does not have a
value for the DDL_DEFAULT_LOCATIONS default (either in your environment
or at the system level) and your environment does not have a =_DEFAULTS
value, the CREATE statement will fail with an error.
subvolume
is the name of the schema subvolume for the schema in which the table is
being created.
Follow these guidelines when using SQL/MX subvolume names:
•
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.
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.