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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-56
Syntax Description of CREATE INDEX
If the index 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 hash 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, a view label, or a stored procedure
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 an index on a single disk volume.
subvolume
is the designated schema subvolume for the schema in which the index 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.