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-74
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
Where sequence-type is INTERNAL for IDENTITY columns and EXTERNAL for
sequence generator.
Cause. The recalibration of the CURRENT_VALUE column in the internal or external
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.
If the IDENTITY column default specification type is GENERATED BY DEFAULT,
recalibrate the CURRENT_VALUE of the internal sequence generator using the
following command:
ALTER TABLE table-name ALTER COLUMN column-name RECALIBRATE TO value NO
SELECT
Where table-name is the table that contains the IDENTITY column.
Where column-name is the IDENTITY column name.
1596 Recalibration of the sequence-type 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.