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

column-name
is the name of a column specified in the references part of a referential
integrity constraint.
Cause You attempted to establish a referential integrity constraint on a column for which
the executing user ID has no REFERENCES privileges.
Effect The operation fails.
Recovery Establish correct column privileges and resubmit.
SQL 1185
1185 The location name is either invalid or missing.
Cause A partition location is either invalid or missing.
Effect The operation fails.
Recovery Specify the correct location for all partitions involved in the affected command.
SQL 1186
1186 Column column-name is of type column-data-type which is not
compatible with the default value’s type, value-data-type.
column-name
is the name of the column that has an error.
column-data-type is the data type of column-name
value-data-type
is the value specified as the default value for the column.
Cause The value specified as the default for the column is incompatible with the type of the
column.
Effect The operation fails.
Recovery Change either the column data type or the value for the default to be compatible
types and resubmit.
SQL 1187
1187 The schema name schema-name is reserved for SQL/MX metadata.
schema-name
is the name of an HP Neoview database schema.
Cause The Neoview database software reserves certain schema names for its own use.
Effect The operation fails.
Recovery See the Neoview SQL Reference Manual for reserved schema names. Choose a name
that is not reserved and reissue the CREATE statement.
SQL 1188
1188 Referential integrity constraint constraint-name for table
table-name could not be created due to circular dependency:
dependency-information.
constraint-name
is the name of a column constraint or table constraint.
table-name
is the name of the table specified in the operation.
dependency-information
is a list of unique constraints that cause the circular
dependency.
Cause You tried to define a referential constraint that is creating a circular dependency,
where one of the columns of the table is referencing a column that belongs to the same table,
either directly or indirectly.
Effect The operation fails.
Recovery None. You cannot define a referential constraint that creates a circular dependency.
43