![HP Neoview Messages Manual Download Page 64](http://html.mh-extra.com/html/hp/neoview-messages/neoview-messages_manual_165138064.webp)
If the IDENTITY column's default specification type is GENERATED ALWAYS AS IDENTITY,
recalibrate the CURRENT_VALUE of the internal sequence generator by using the ALTER
TABLE ALTER COLUMN SET INCREMENT BY statement and manual calibration instructions.
SQL 1598
1598 The new CURRENT_VALUE, current-value, for the IDENTITY column,
column-name, for the table, table-name, will be greater than the maximum
allowed, maximum-value.
current-value
is the CURRENT_VALUE of the IDENTITY column.
column-name
is the name of the IDENTITY column.
table-name
is the name of the table that contains the IDENTITY column.
maximum-value
is the maximum allowed value for the IDENTITY column.
Cause
The new CURRENT_VALUE (either user-specified or calculated) is greater than the
maximum value allowed for the data type of the IDENTITY column or is greater than the value
of the MAXVALUE internal-sequence-generator option. The calculation of the
CURRENT_VALUE is performed by adding the maximum value of the IDENTITY column to
the INCREMENT BY value of the internal sequence generator.
Effect
The statement fails to execute.
Recovery
To attempt recovery, determine if changing the options of the internal sequence
generator, using the ALTER TABLE ALTER COLUMN SET commands, could result in the
calculation of a valid value for the new CURRENT_VALUE maximum. If this is possible, alter
the internal sequence generator options, and then resubmit the RECALIBRATE command. If
the user-specified value fails, resubmit the RECALIBRATE command using a value less than
the maximum value that is causing the failure.
SQL 1599
1599 The recalibration value is greater-or-less-than-an-option value,
recalibration-value, of the IDENTITY column, column-name, for the table,
table-name.
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
recalibration-value
is the recalibration value that you specified.
column-name
is the name of the IDENTITY column.
table-name
is the name of the table that contains the IDENTITY
column.
Cause
The recalibration value that you specified does not comply with these rules:
•
The recalibration value must not be less than the START WITH and MINVALUE options
of the internal sequence generator.
•
The recalibration value must not be greater than the MAXVALUE option of the internal
sequence generator.
•
The recalibration value must not be greater than the maximum value allowed for the data
type of the IDENTITY column.
•
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 statement fails to execute.
64
Data Definition Language (DDL) Messages (1000 Through 1999)
Summary of Contents for Neoview Messages
Page 12: ...12 ...
Page 66: ...66 ...
Page 129: ...Recovery Supply the input values for the IDENTITY column 129 ...
Page 130: ...130 ...
Page 172: ...172 ...
Page 178: ...178 ...
Page 184: ...184 ...
Page 238: ...238 ...
Page 266: ...266 ...
Page 268: ...268 ...
Page 350: ...350 ...
Page 378: ...378 ...
Page 384: ...384 ...
Page 400: ......