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-76
Where col-name is the IDENTITY column name.
Where table-name is the table that contains the IDENTITY column.
Cause. The specified recalibration value does not comply with these rules:

For the IDENTITY column, the recalibration value must not be less than the
START WITH and MINVALUE options.

The recalibration value must not be greater than the MAXVALUE option of the
IDENTITY column.

The recalibration value must not be greater than the maximum value allowed
for the IDENTITY column data type.

If the statement does not contain the NO SELECT option, the recalibration
value provided must be greater than the maximum value in the IDENTITY
column.
Effect. The operation fails.
Recovery. Correct the recalibration value, and resubmit the statement.
SQL 1600
Where table-name is the table that contains the IDENTITY column.
Where col-name is the IDENTITY column name.
Cause. The table containing the IDENTITY column could not be locked in SHARED
MODE because there is a locking contention on the table.
Effect. The operation fails.
Recovery. Resubmit the statement when the locking contention has cleared.
SQL 1601
Where col-name is the IDENTITY column name.
Where table-name is the table that contains the IDENTITY column.
Cause. The NO SELECT syntax with the default specification type of GENERATED
ALWAYS AS IDENTITY is not allowed.
Effect. The operation fails.
1600 Unable to lock table, table-name, for the IDENTITY
column, col-name, during recalibration.
1601 Recalibration of the GENERATED ALWAYS AS IDENTITY column,
col-name, for the table, table-name, is not allowed with NO
SELECT.