Neoview Messages Manual (R2.3)

SQL 1088
1088 The system generated column SYSKEY must be specified last or not
specified at all in the STORE BY column list.
Cause If the system-generated column SYSKEY is specified in the STORE BY list of columns,
it must be specified last.
Effect The operation fails.
Recovery Correct the STORE BY clause and resubmit.
SQL 1089
1089 The system generated column SYSKEY must be specified last or not
specified at all in the index column list.
Cause The system-generated SYSKEY column was not the last column in a CREATE INDEX
statement.
Effect The operation fails.
Recovery Change the column list to place SYSKEY at the end of the list and resubmit the
statement.
SQL 1090
1090 Self-referencing constraints are currently not supported.
Cause You attempted to create a self-referencing constraint. A referential constraint is
self-referencing if the foreign key is referencing the primary key of the same table.
Effect The operation fails.
Recovery Remove the self-reference and resubmit.
SQL 1094
1094 Object object-name could not be dropped because it is not of type
object-type.
object-name
is the ANSI name of the object stated in the DROP command.
object-type
is the type of object that was stated in the DROP command.
Cause A DROP TABLE specified an object that is not a base table, or a DROP VIEW specified
an object that is not a view, or a DROP PROCEDURE specified an object that is not a procedure.
Effect The operation fails.
Recovery Reissue the DROP statement with the correct combination of specified object type
and actual object type.
SQL 1095
1095 The PARTITION BY column column-name should also be part of the
clustering/storage key.
column-name
is the name of a column of the specified table.
Cause This error is reported if a column specified in the partitioning key of the PARTITION
BY (partitioning_columns) clause of a CREATE TABLE or CREATE INDEX statement is
not also a member of the clustering key.
Effect The table or index is not created.
Recovery Either remove the offending column from the partitioning key specification (and
possibly replace it with a column that is a member of the clustering key) or add the offending
column to the clustering key by using the STORE BY clause or by adding it to the primary key.
30 Data Definition Language (DDL) Messages (1000 Through 1999)