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

SQL/MX Clauses
HP NonStop SQL/MX Reference Manual—540440-003
7-6
Considerations for PARTITION
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 only characters from the ISO88591 character set.
The values you specify on the FIRST KEY clause cannot be the same as the
values you specify on the FIRST KEY clause for another partition of the same table
or index.
For a table partition, the values in the FIRST KEY clause have a one-to-one
correspondence with the columns in the partitioning key of the table.
For an index partition, the values in the FIRST KEY clause have a one-to-one
correspondence with the partitioning key of the index.
LOCATION [\node.]$volume[.subvolume.file-name]
specifies a disk volume and, optionally, a node, subvolume and file name for the
partition. The node must be 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.
The subvolume must be the designated subvolume for the schema in which the
table or index is being created. More than one partition of a given table or index
can be located on a single disk volume.
partition-name
is an SQL identifier for a partition.
ATTRIBUTE
specifies attributes of the partition. See EXTENT on page 8-6 and MAXEXTENTS
on page 8-7 for more information.
Considerations for PARTITION
Data Type Limitations
You cannot mix APPROXIMATE data types with EXACT data types in specifying a first
key value or a default value for a column. For example, if the column has type
NUMERIC (9,0), for the value of that column in a FIRST KEY clause, 1000 will be
accepted, but 10E4 will not (an error is returned if 10E4 is specified in this example).
EXTENT Controls the size of extents that will be allocated on disk.
MAXEXTENTS Controls the maximum disk space to be allocated.