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

Note If the data type is a LARGEINT, the SQL 1576 message does not contain the column
name. This error is caught, but the column name is not known.
The corresponding error message isFor this example . . .
*** ERROR[1576] The MAXVALUE value is greater than
the maximum allowed for the IDENTITY column A data
type.
Identity column A is defined as SMALLINT UNSIGNED,
and MAXVALUE is 65536.
*** ERROR[1576] The MAXVALUE value is greater than
the maximum allowed for the IDENTITY column data
type.
IDENTITY column A is defined as LARGEINT, and
MAXVALUE is 9223372036854775807.
SQL 1590
1590 Column col-name is not an IDENTITY column.
col-name
is the name of the IDENTITY column.
Cause You specified a column to alter that is not an IDENTITY column.
Effect The statement fails.
Recovery Specify the sequence generator option to be altered for a column that is an IDENTITY
column.
SQL 1591
1591 The MAXVALUE option for the col-name must be greater than the
current value of seq-gen-value.
col-name
is the name of the IDENTITY column.
seq-gen-value
is the numeric value of the sequence generator.
Cause You specified a MAXVALUE option that is less than the current value of the sequence
generator.
Effect The statement fails.
Recovery Specify a MAXVALUE internal sequence generator option that is larger than the
current value of the sequence generator.
SQL 1592
1592 Only the MAXVALUE or INCREMENT BY option can be altered for the
col-name.
col-name
is the name of the IDENTITY column.
Cause You specified a sequence generator option other than the MAXVALUE or INCREMENT
BY option to alter.
Effect The statement fails.
Recovery Specify either the MAXVALUE or INCREMENT BY sequence generator option to
be altered for the IDENTITY column.
SQL 1593
1593 Only one col-name option can be altered at a time.
col-name
is the name of the IDENTITY column.
Cause You specified more than one sequence generator option to alter for an IDENTITY
column.
Effect The statement fails.
Recovery Specify either the MAXVALUE or INCREMENT BY sequence generator option to
be altered for the IDENTITY column.
60 Data Definition Language (DDL) Messages (1000 Through 1999)