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

HP NonStop SQL/MX Reference Manual—540440-003
7-1
7 SQL/MX Clauses
Clauses are used by SQL/MX statements to specify default values, ways to sample or
sort data, how to store physical data, how to partition file, and other details.
This section describes these clauses for SQL/MX objects:
DEFAULT Clause on
page 7-2
Specifies a default value for a column being created.
PARTITION Clause on
page 7-5
Creates one or more secondary partitions for a table or
index.
SAMPLE Clause on
page 7-8
Specifies the sampling method used to select a subset of
the intermediate result table of a SELECT statement.
SEQUENCE BY Clause
on page 7-18
Specifies the order in which to sort rows of the
intermediate result table for calculating sequence
functions.
STORE BY Clause on
page 7-22
Specifies the organization and storage order of the
physical files that make up a table.
TRANSPOSE Clause
on page 7-25
Generates, for each row of the SELECT source table, a
row for each item in the transpose item list.