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

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-100
Syntax Description of CREATE TABLE
values for the IDENTITY column. 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. The default is the
value provided in MINVALUE option of the internal sequence generator. If the
MINVALUE is omitted or NO MINVALUE is specified, the default is 0 (zero).
INCREMENT BY signed-numeric-literal
increments the CURRENT_VALUE by signed-numeric-literal to obtain
the next value in the sequence. See SG Table on page 2-118. 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
the non-negative value of the data type of the IDENTITY column that specifies
the maximum value of the cycle range. It cannot be greater than the maximum
value of the data type of the IDENTITY column. It must be greater than the
INCREMENT BY value. If NO MAXVALUE is specified or this option is omitted,
the maximum value is the maximum value of the data type of the IDENTITY
column.
MINVALUE signed-numeric-literal | NO MINVALUE
A non-negative value that specifies the minimum value of the cycle range. If
NO MINVALUE is specified or if this option is omitted, the minimum value is the
minimum value of the data type of the IDENTITY column.
NO CYCLE
means that when the MAXVALUE maximum is reached for the IDENTITY
column, an error is raised that indicates the maximum has been exceeded.
Values will not be restarted. If an artificially low cycle range was created by
setting the MAXVALUE value lower than the natural maximum allowed for the
data type, you can use the ALTER TABLE ALTER COLUMN SET MAXVALUE
option to raise the maximum value up to the natural maximum allowed for the
data type. Raising the MAXVALUE allows more available values in the cycle
range for the internal sequence generator. Inserts will be successful until the
new MAXVALUE is reached. For more information, see the Syntax Description
of ALTER TABLE on page 2-14.
sg-location
specifies a volume and optionally the node, subvolume, and filename for the SG
Table. See SG Table on page 2-118.