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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-83
Syntax Description of CREATE TABLE
key-column-list
bases the clustering key on the columns in the key-column-list. The key
columns in key-column-list must be specified as NOT NULL NOT
DROPPABLE and cannot have a combined length of more than 247 bytes.
The default is PRIMARY KEY if you specified a PRIMARY KEY clause that has the
NOT DROPPABLE constraint in the CREATE TABLE statement.
If you omit the STORE BY clause and you do not specify a PRIMARY KEY that
has the NOT DROPPABLE constraint, the storage order is determined only by the
SYSKEY. You cannot partition a table stored only by SYSKEY. See SYSKEYs on
page 6-61.
LOCATION [\node.]$volume[.subvolume.file-name]
[NAME partition-name]
specifies a physical location for the primary partition of the table.
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 system named in the =_DEFAULTS define if none is specified).
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.