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

SQL 1156
1156 Synonym name does not exist or object type is invalid for the
current operation.
Cause You specified a create or alter of synonym name on an object that is not a table or
view.
Effect The operation fails.
Recovery Correct the syntax so that the correct name is used.
SQL 1157
1157 Synonym object name is the same as previous mapping.
Cause You specified an alter of synonym on an object name, which is the same as its previous
mapping.
Effect The operation succeeds with a warning.
Recovery None.
SQL 1158
1158 Object name already exists.
Cause You specified a create of synonym name on an object, but an object of that name
already exists.
Effect The operation fails.
Recovery Correct the syntax so that the correct name is used.
SQL 1159
1159 name does not exist.
Cause You specified an alter or drop of synonym name, but a synonym of that name does
not exist.
Effect The operation fails.
Recovery Correct the syntax so that the correct name is used.
SQL 1160
1160 A mismatch between the NOT DROPPABLE PRIMARY KEY constraint and
the STORE BY clause was detected. When both clauses are specified, the
STORE BY key column list must be the same as, or a prefix of, the PRIMARY
KEY column list. This mismatch is caused by differences between the
columns themselves, the order of columns, or the ASC/DESC attribute.
Cause You attempted to create a table that contains both a NOT DROPPABLE PRIMARY
KEY constraint and a STORE BY clause. The syntax specified is not correct. The STORE BY
column list must be the same as, or a prefix of, the NOT DROPPABLE PRIMARY KEY column
list.
Effect The operation fails.
Recovery If you want the STORE BY column list that specifies the clustering key to be different
than the PRIMARY KEY, specify a DROPPABLE PRIMARY KEY. If you want the PRIMARY
KEY to be the same as the STORE BY key, do not specify a STORE BY clause. Correct the syntax
and resubmit.
SQL 1161
1161 System generated column SYSKEY cannot be specified as part of the
PARTITION BY clause.
39