SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-41
SQL 1186
Where column-name is the name of the column that has an error.
Where column-data-type is the data type of column-name
Where 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
Where schema-name is the name of an SQL/MX schema.
Cause. SQL/MX reserves certain schema names for its own use.
Effect. The operation fails.
Recovery. See the SQL/MX Reference Manual for reserved schema names. Choose
a name that is not reserved and reissue the CREATE statement.
SQL 1188
Where constraint-name is the name of a column constraint or table constraint.
Where table-name is the name of the table specified in the operation.
Where 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.
1186 Column column-name is of type column-data-type which is
not compatible with the default value’s type, value-data-
type.
1187 The schema name schema-name is reserved for SQL/MX
metadata.
1188 Referential integrity constraint constraint-name for
table table-name could not be created due to circular
dependency: dependency-information.