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

Cause The index required by the constraint is disabled, so the constraint cannot be enabled.
Effect The operation failed.
Recovery Populate index and retry the request.
SQL 1519
1519 Constraint constraint on table table cannot be disabled because
it is a foreign key constraint.
constraint
is the name of the constraint.
table
is the name of the table.
Cause The specified constraint is defined as a foreign key constraint and cannot be disabled.
Effect The operation failed.
Recovery No recovery is available.
SQL 1540
1540 The NO POPULATE clause is not allowed for index index-name on
volatile table table-name.
index-name
is the name of the index.
table-name
is the name of the table.
Cause This error occurs when you try to separate the index creation (CREATE ... INDEX ...
NO POPULATE) and population (POPULATE INDEX …) steps. However, POPULATE INDEX
does not work with a volatile index. Therefore, the CREATE ... INDEX ... NO POPULATE
syntax is not supported for volatile indexes.
Effect The operation fails, and the volatile index is not created.
Recovery Remove the NO POPULATE clause from the CREATE INDEX statement, and try
recreating the index.
SQL 1570
1570 The MAXVALUE for the sequence generator must be greater than the
MINVALUE for col-name.
col-name
is the name of the IDENTITY column.
Cause You specified a MAXVALUE that is less than the MINVALUE for the sequence
generator option.
Effect The statement fails.
Recovery Specify a value for MAXVALUE that is greater than the MINVALUE, and resubmit
the statement.
SQL 1571
1571 The INCREMENT BY value cannot be zero for col-name.
col-name
is the name of the IDENTITY column.
Cause You specified a value of zero for the INCREMENT BY option for the sequence
generator.
Effect The statement fails.
Recovery Specify a value greater than zero for the INCREMENT BY option, and resubmit
the statement.
60 Data Definition Language (DDL) Messages (1000 Through 1999)