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-69
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 MINVALUE.
Effect. The operation fails.
Recovery. Specify MAXVALUE greater than 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 greater than zero for 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.
Cause. A negative value is specified for the internal sequence generator option (seq-
gen-option).
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.