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-70
SQL 1510
Where col-name is the IDENTITY column name.
Cause. An unsupported data type is specified for IDENTITY column.
Effect. The operation fails.
Recovery. Modify the IDENTITY column data type to LARGEINT, unsigned INTEGER
or unsigned SMALLINT, and resubmit the statement.
SQL 1570
Where seq-name is the sequence generator or the IDENTITY column ANSI name.
Cause. For the sequence or IDENTITY column, the MAXVALUE specified is less than
the MINVALUE.
Effect. The operation fails.
Recovery. Specify the MAXVALUE greater than the MINVALUE, and resubmit the
statement.
SQL 1571
Where seq-name is the sequence generator or the IDENTITY column ANSI name.
Cause. For the sequence or IDENTITY column, the INCREMENT BY option value is
zero.
Effect. The operation fails.
Recovery. Specify a non-zero value for the INCREMENT BY value, and resubmit the
statement.
SQL 1572
Where seq-gen-option is the sequence generator option.
Where col-name is the IDENTITY column name.
1510 Identity column col-name can be of the following data
types only: LARGEINT, unsigned INTEGER and unsigned SMALLINT.
1570 The MAXVALUE for the sequence generator must be greater
than the MINVALUE for seq-name.
1571 The INCREMENT BY value cannot be zero for seq-name.
1572 The seq-gen-option value cannot be a negative number for
col-name.