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

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
3-70
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, START WITH option value is not in the range
between MINVALUE and MAXVALUE.
Effect. The operation fails.
Recovery. Specify 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 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.