SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
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 seq-name is the sequence generator or the IDENTITY column ANSI name.
Cause. For the sequence or the IDENTITY column, the START WITH value is not in
the MINVALUE and MAXVALUE range.
Effect. The operation fails.
Recovery. Specify the START WITH value greater than or equal to the MINVALUE
and lesser than or equal to the 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 seq-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.