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

first-key-string
is the erroneous value used in the FIRST KEY clause for
column-name.
Cause In a CREATE TABLE statement, a value specified as first key is not a quoted string,
but the type of the column for which this value is specified is one of the character data types.
Effect The operation fails.
Recovery Correct the value first-key-string to be a type that is compatible with the
type of column column-name and resubmit.
SQL 1145
1145 The catalog name catalog-name is reserved for SQL/MX metadata.
catalog-name
is the name of an HP Neoview database catalog.
Cause The Neoview database software reserves certain catalog names for its own use.
Effect The operation fails.
Recovery See the Neoview SQL Reference Manual for reserved names. Change catalog-name
to a name that is not reserved and resubmit.
SQL 1146
1146 Object object-name could not be altered because it is not a
object-type.
object-name
is the name of the object being requested.
object-type
is the type of object required for the DDL statement issued.
Cause The type of the object specified in the command is inconsistent with the DDL command
being used. For example, this occurs if DROP TABLE is used, and the object you specify is an
INDEX.
Effect The operation fails.
Recovery Check that the correct object name was specified and execute a statement that is
consistent with that type of object.
SQL 1147
1147 System-generated column column-name of base table table-name cannot
appear in a unique or primary key constraint.
column-name
is the SYSKEY column.
table-name
is the name of the table.
Cause You tried to create a unique or primary key constraint on the SYSKEY column.
Effect The operation fails.
Recovery Do not use the SYSKEY as part of the unique or primary key.
SQL 1148
1148 System-generated column column-name of base table table-name cannot
appear in a referential integrity constraint definition.
column-name
is the SYSKEY column.
table-name
is the name of the table.
Cause You tried to create a referential constraint on a table column that is the SYSKEY, which
is not supported.
Effect The operation fails.
Recovery Do not use the SYSKEY as part of the referenced key.
37