SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual—544518-011
3-43
SQL 1187
Where schema-name is the name of an SQL/MX schema.
Cause. NonStop 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.
Recovery. None. You cannot define a referential constraint that creates a circular
dependency.
SQL 1190
Where catalog-location is a name of the form $vol.sql.catalogs.
Where error-number identifies the error encountered.
Cause. Unable to locate the device for the SQL/MP system catalog or the label of
$vol.sql.catalogs.
Effect. The operation fails.
Recovery. Check that the device for the SQL/MP system catalog and the file
$vol.sql.catalogs exist. If they do, contact your service provider.
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.
1190 SQL/MP system catalog catalog-location could not be
found - error error-number.