SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
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-6
Creates one or more secondary partitions for a table or
index.
SAMPLE Clause on
page 7-9
Specifies the sampling method used to select a subset of
the intermediate result table of a SELECT statement.
SEQUENCE BY Clause
on page 7-19
Specifies the order in which to sort rows of the
intermediate result table for calculating sequence
functions.
STORE BY Clause on
page 7-23
Specifies the organization and storage order of the
physical files that make up a table.
TRANSPOSE Clause
on page 7-26
Generates, for each row of the SELECT source table, a
row for each item in the transpose item list.