SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-158
CREATE TABLE Statement
PHYSVOL volume-name
If SMF is installed on your node, the PHYSVOL option directs SQL to override
SMF and place the table or primary table partition on the physical volume
volume-name. For volume-name, specify either a physical volume or equivalent
DEFINE. Do not specify the node name in your volume name.
This option is available only if you specify a virtual volume for
table.volume-name must belong to the virtual volume you specify.
You can specify a physical volume for each secondary partition in the PARTITION
clause.
CLUSTERING KEY key-column-list
specifies the set of columns that make up a clustering key for a key-sequenced
table. Each column in the set must be a column previously defined for the table.
The columns do not need to be contiguous, but their combined length cannot
exceed 247 bytes (not including the 8-byte SYSKEY).
You can specify only one clustering key (or one primary key) for any particular
key-sequenced table. If you do not specify either the PRIMARY KEY clause or
CLUSTERING KEY clause for a key-sequenced table, SQL adds a SYSKEY
column to the table to use as the primary key.
References to keys in other tables, or any references that require a unique key,
should always use a primary key rather than a SYSKEY or clustering key.
Columns in the clustering key definition cannot be updated and cannot contain null
values, even if you omit the NOT NULL clause in the column definition.
For information, see Primary Keys on page P-27, Syskeys on page S-90, or
Clustering Keys
on page C-28.
[ { ORGANIZATION } { K[EY SEQUENCED] } ]
[ { ORGANISATION } { E[NTRY SEQUENCED] } ]
[ { R[ELATIVE] } ]
specifies the file organization for the physical file that holds the table. For more
information, see File Organizations
on page F-8. The default is KEY
SEQUENCED.
PARTITION ( partition [ , partition ] ... )
defines the secondary partitions of a partitioned table.
partition is the definition of a single secondary partition and includes the
location of the partition, the first key value for the partition, and (optionally) the
catalog, physical volume, and EXTENT and MAXEXTENTS values for the partition.
For information, see PARTITION Clause on page P-16.