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-75
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.
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.
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.