Neoview SQL Reference Manual (R2.4)

the number of pools or if pool_number is an invalid number, an error is generated. See
“DISK POOL” (page 89).
NO INSERTLOG | INSERTLOG
specifies whether update and delete operations are recorded in the table’s IUD log, if one
exists.
When a table is defined with the INSERTLOG attribute, logging operations ignore delete
and update operations and log inserts only.
This logging is needed to maintain ON REQUEST materialized views. If no ON REQUEST
materialized views are defined on the table, this attribute has no affect.
AS select-query
specifies a select query which is used to populate the created table. A select query can be any
SQL select statement.
column data-type
specifies the name and data type for a column in the table. At least one column definition is
required in a CREATE TABLE statement.
column is an SQL identifier. column must be unique among column names in the table. If
the name is a Neoview SQL reserved word, you must delimit it by enclosing it in double
quotes. Such delimited parts are case-sensitive. For example: "join".
data-type is the data type of the values that can be stored in column. A default value must
be of the same type as the column, including the character set for a character column. “Data
Types” (page 229).
DEFAULT default | NO DEFAULT
specifies a default value for the column or specifies that the column does not have a default
value. “DEFAULT Clause” (page 294).
identity-column-specification
indicates that a particular column is a sequence-generating IDENTITY column. Neoview
SQL will generate unique values for this column by default. See “Generating Values For an
IDENTITY Column” (page 85).
GENERATED BY DEFAULT AS IDENTITY | GENERATED ALWAYS AS IDENTITY
GENERATED BY DEFAULT AS IDENTITY
creates an IDENTITY column, either system-generated or user-supplied. DEFAULT
specification in the place of a value is allowed. The internal sequence generator is created
when an IDENTITY column is specified.
GENERATED ALWAYS AS IDENTITY
creates an IDENTITY column. A user-supplied value is NOT allowed. DEFAULT
specification in the place of a value is allowed. The internal sequence generator is created
when an IDENTITY column is specified.
START WITH signed-numeric-literal
start value of the cycle range for the IDENTITY column. Default is 0 (zero).
INCREMENT BY signed-numeric-literal
increments the current value to obtain the next value. Default is 1 (one). The INCREMENT
BY value cannot be greater than the maximum value of the data type of the IDENTITY
column.
MAXVALUE signed-numeric-literal | NO MAXVALUE
minimum non-negative value of the data type of the IDENTITY column starting the cycle
range. The default is 0 (zero). Cannot be greater than the maximum value of the data type
of the IDENTITY column. Must be greater than the INCREMENT BY value. If NO
74 SQL Statements