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-75
Where value is the CURRENT_VALUE of the IDENTITY column.
If the IDENTITY column default specification type is GENERATED ALWAYS AS
IDENTITY, recalibrate the CURRENT_VALUE of the internal sequence generator
using the ALTER TABLE ALTER COLUMN SET INCREMENT BY manual calibration
instructions.
SQL 1598
Where current-value is the CURRENT_VALUE of the IDENTITY column.
Where col-name is the IDENTITY column name.
Where table-name is the table which contains the IDENTITY column.
Where maximum-value is the maximum allowed value for the IDENTITY column.
Cause. The new CURRENT_VALUE is greater than the maximum value allowed for
the IDENTITY column data type or is greater than the MAXVALUE option. The
CURRENT_VALUE is calculated by adding INCREMENT BY option value to the base
current value.
Effect. The operation fails.
Recovery. Determine if changing the options of the IDENTITY column results in
calculation of a valid new CURRENT_VALUE maximum. If a new maximum does exist,
alter the options using ALTER TABLE ALTER COLUMN SET command, and resubmit
the RECALIBRATE command.
SQL 1599
Where greater-or-less-than-an-option indicates whether the recalibration
value is greater or less than a specific value and is one of these phrases:

Is less than the current maximum

Is less than the START WITH option

Is less than the MINVALUE option

Is greater than the MAXVALUE
Where recalibration-value is the specified recalibration value.
1598 The new CURRENT_VALUE, current-value, for the IDENTITY
column, col-name, for the table, table-name, will be greater
than the allowed, maximum-value.
1599 The recalibration value is greater-or-less-than-an-option
value, recalibration-value, of the IDENTITY column, col-name,
for the table, table-name.