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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-84
Syntax Description of CREATE TABLE
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
column list, and you cannot specify a FIRST KEY value for the SYSKEY
column. This limitation does not apply to a user-created SYSKEY column.
ADD partn-defn
defines a single secondary partition and includes the LOCATION of the
partition.
partn-defn is:
LOCATION [\node.]$volume[.subvolume.file-name]
[EXTENT ext-size | (pri-ext-size [,sec-ext-size])]
[MAXEXTENTS num-extents]
[NAME partition-name]
specifies a volume and optionally the node, subvolume, and filename for
the partition.
node
is the name of a node on the Expand network. For Guardian files
representing a table or index partition or a view label, node can be any
node from which the object's catalog is visible.
volume
is the name of an audited, non-SMF DAM volume on the specified node (or
the Guardian volume named in the =_DEFAULTS define if none is
specified). If you do not specify a LOCATION clause, NonStop SQL/MX
uses the default volume named in the =_DEFAULTS define.
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.
You can locate more than one partition of a table on a single disk volume.