SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-20
SQL 1075
Where schema-name is the name of a schema in the specified catalog.
Cause. An attempt was made to drop a catalog that is not empty.
Effect. The catalog is not dropped. None of its schemas are dropped.
Recovery. Drop all schemas in the catalog and resubmit.
SQL 1077
Where table-name is the name of the metadata table.
Where view-name is the name of a view.
Cause. NonStop SQL/MX required metadata information about object view-name
and was unable to find it in table-name.
Effect. The operation fails.
Recovery. None. Contact your service provider.
SQL 1078
Where location-name is a name specified in a LOCATION clause.
Cause. An invalid name was supplied in a LOCATION clause.
Effect. The operation fails.
Recovery. See the SQL/MX Reference Manual for limitations on names allowed in the
LOCATION clause. Correct the name and resubmit.
SQL 1079
Cause. See the accompanying error message for the cause.
Effect. The operation fails.
1075 The catalog must be empty. It contains at least one
schema schema-name.
1077 Metadata table table-name does not contain information
for view view-name.
1078 The format of the specified location name ‘location-
name’ is not valid.
1079 SQL/MX was not able to prepare the statement.