SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-58
Syntax Description of CREATE INDEX
ADD partn-defn
defines a single secondary hash partition and includes the LOCATION of the
partition.
LOCATION [\node.]$volume[.subvolume.file-name]
[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 system 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.
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.
file-name
is an optional Guardian file name. file-name names must be 8
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 an SQL/MX extension.
See PARTITION Clause on page 7-5.