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-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 col-name is the IDENTITY column name.
Cause. For the IDENTITY column, the MAXVALUE specified is less than the
MINVALUE.
Effect. The operation fails.
Recovery. Specify a MAXVALUE greater than the MINVALUE, and resubmit the
statement.
SQL 1571
Where col-name is the IDENTITY column name.
Cause. For the IDENTITY column, the INCREMENT BY option value is zero.
Effect. The operation fails.
Recovery. Specify a value other than zero for the INCREMENT BY option, 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 col-name.
1571 The INCREMENT BY value cannot be zero for col-name.
1572 The seq-gen-option value cannot be a negative number for
col-name.