Neoview Messages Manual (Volume 1) (R2.5)

Effect The statement fails.
Recovery Specify either the MAXVALUE or INCREMENT BY sequence generator option to
be altered for the IDENTITY column.
SQL 1594
1594 An error occurred trying to access the current value of the IDENTITY
column col-name.
col-name
is the name of the IDENTITY column.
Cause An internal error occurred when the platform tried to access the current value of the
IDENTITY column internal sequence generator.
Effect The statement fails.
Recovery See the additional diagnostic messages for details.
SQL 1595
1595 The MAXVALUE option for the IDENTITY column col-name must be a
valid numeric value. NO MAXVALUE is not allowed.
col-name
is the name of the IDENTITY column.
Cause You specified NO MAXVALUE as the sequence generator option to alter for an
IDENTITY column.
Effect The statement fails.
Recovery Specify a value for the sequence generator option that is a valid number for the
maximum value and is allowed for the data type. Then resubmit the statement.
SQL 1596
1596 Recalibration of the internal sequence generator failed. Please
see additional messages for details.
Cause The recalibration of the CURRENT_VALUE column in the internal sequence generator
table failed.
Effect The statement fails to execute.
Recovery Review the additional messages provided with this error for the internal UPDATE
statement failure. The additional messages will help you determine why the update to the
CURRENT_VALUE column failed.
SQL 1597
1597 The maximum of the IDENTITY column, column-name, for the table,
table-name, could not be obtained.
column-name
is the name of the IDENTITY column.
table-name
is the name of the table that contains the IDENTITY column.
Cause The maximum value of the IDENTITY column could not be obtained from the table.
Effect The statement fails to execute.
Recovery Resubmit the statement. If resubmitting the statement fails, manually obtain the
maximum value of the IDENTITY column. Increment this value by using the value of the
INCREMENT BY internal-sequence-generator option of the IDENTITY column. If the IDENTITY
column's default specification type is GENERATED BY DEFAULT, recalibrate the
CURRENT_VALUE of the internal sequence generator by using this syntax:
ALTER TABLE table-name ALTER COLUMN column-name RECALIBRATE TO value
NO SELECT
63