SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-71
Cause. A negative value is specified for the internal sequence generator option (seq-
gen-option).
Effect. The operation fails.
Recovery. Specify a positive value for the internal sequence generator option, and
resubmit the statement.
SQL 1573
Where col-name is the IDENTITY column name.
Cause. For the IDENTITY column, the START WITH option value is not in the range
between MINVALUE and MAXVALUE.
Effect. The operation fails.
Recovery. Specify a START WITH option value greater than or equal to MINVALUE
and less than or equal to MAXVALUE, and resubmit the statement.
SQL 1574
Where col-name is the IDENTITY column name.
Cause. An unsupported option (CYCLE) is specified. Currently, only the NO CYCLE
option is supported.
Effect. The operation fails.
Recovery. Specify NO CYCLE option and resubmit the statement .
SQL 1575
Where col-name is the IDENTITY column name.
Cause. The INCREMENT BY internal sequence generator option value specified was
greater than MAXVALUE.
Effect. The operation fails.
Recovery. Specify an INCREMENT BY option value less than MAXVALUE, and
resubmit the statement.
1573 The START WITH value must be greater than or equal to the
MINVALUE and less than or equal to the MAXVALUE for col-name.
1574 The CYCLE option is currently not supported for col-name.
1575 The INCREMENT BY value cannot be greater than the
MAXVALUE for col-name.