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-76
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.
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.
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.
1600 Unable to lock table, table-name, for the IDENTITY
column, col-name, during recalibration.