Neoview SQL Reference Manual (R2.4 SP2)

5 SQL Clauses
Clauses are used by Neoview SQL statements to specify default values, ways to sample or sort
data, how to store physical data, and other details.
This section describes:
• “DEFAULT Clause” specifies a default value for a column being created.
• “FORMAT Clause” specifies the format to use.
• “SAMPLE Clause” specifies the sampling method used to select a subset of the intermediate
result table of a SELECT statement.
• “SEQUENCE BY Clause” specifies the order in which to sort rows of the intermediate result
table for calculating sequence functions.
• “TRANSPOSE Clause” generates, for each row of the SELECT source table, a row for each
item in the transpose item list.
301