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-72
SQL 1576
Where seq-gen-option is the IDENTITY column option.
Where col-name is the IDENTITY column name.
Cause. The IDENTITY column option (seq-gen-option) value is greater than the
maximum value allowed for the IDENTITY column data type.
Effect. The operation fails.
Recovery. Specify the sequence generator option value less than or equal to the
maximum value allowed for the IDENTITY column data type, and resubmit the
statement.
Note: For IDENTITY columns of LARGEINT data type, the error message does not
contain the column name.
For example:
IDENTITY column A of type unsigned SMALLINT with MAXVALUE
65536:
*** ERROR[1576] The MAXVALUE value is greater than the
maximum allowed for the IDENTITY column A data type.
IDENTITY column A of type LARGEINT with MAXVALUE
9223372036854775807:
*** ERROR[1576] The MAXVALUE value is greater than the
maximum allowed for the IDENTITY column data type.
SQL 1590
Where col-name is the IDENTITY column name.
Cause. Specified column name for ALTER operation is not an IDENTITY column.
Effect. The operation fails.
Recovery. Correct the IDENTITY column name, and resubmit the statement.
SQL 1591
Where col-name is the IDENTITY column name.
1576 The seq-gen-option value is greater than the maximum
allowed for col-name data type.
1590 Column col-name is not an IDENTITY column.
1591 The MAXVALUE option for the col-name must be equal to or
greater than the current value of seq-gen-value.