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-74
Recovery. For details, see the additional diagnostic messages. Correct the cause, and
resubmit the statement.
SQL 1595
Where col-name is the IDENTITY column name.
Cause. An unsupported option (NO MAXVALUE) is specified for an ALTER operation.
Effect. The operation fails.
Recovery. Specify a valid numeric value for the MAXVALUE option, and resubmit the
statement.
SQL 1596
Cause. The recalibration of the CURRENT_VALUE column in the internal sequence
generator table failed.
Effect. The operation fails.
Recovery. See the additional messages provided with the failure. The additional
messages can help you determine the root cause. Correct the cause, and resubmit the
statement.
SQL 1597
Where col-name is the IDENTITY column name.
Where table-name is the table that contains the IDENTITY column.
Cause. The maximum value of the IDENTITY column cannot be obtained from the
table.
Effect. The operation fails.
Recovery. Resubmit the statement. If it fails, manually obtain the maximum value of
the IDENTITY column. Increment this value by using the INCREMENT BY option
value for the IDENTITY column.
1595 The MAXVALUE option for the IDENTITY column col-name must
be a valid numeric value. NO MAXVALUE is not allowed.
1596 Recalibration of the internal sequence generator failed.
Please see additional messages for details.
1597 The maximum of the IDENTITY column, col-name, for the
table, table-name, could not be obtained.