HP NonStop SQL/MX, Messages Manual

Page: 34 / 752

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual — 640324-001
3 -8
Cause. You attempted to drop the schema containing the metadata tables for the
catalog.
Effect. No SQL objects are dropped.
Recovery. Use DROP SCHEMA statements to drop all the user-created schemas in
the catalog. Then use the DROP CATALOG statement to drop the catalog. The
schema
definition-schema-name
is dropped when you drop its catalog.
SQL 1028
Where
object-name
is the name of an SQL/MX object existing in the schema.
Cause. You attempted to drop a schema that contains one or more objects.
Effect. The schema is not dropped.
Recovery. Either drop all the objects in
schema-name
and resubmit the statement, or
resubmit the drop statement using the CASCADE option.
SQL 1029
Where
object-name
is the name supplied in a CREATE statement.
Cause. This error can result from various CREATE statements. See the
accompanying error messages to determine the cause.
Effect. The object is not created.
Recovery. Apply the recovery of the accompanying error messages.
SQL 1030
Where
Guardian name
is the name of an SQL/MX file.
Where
error
is a file system error number.
Cause. A file system error occurred while accessing the file label for
Guardian name
and the stored row count could not be retrieved.
Effect. The operation fails.
Recovery. Apply the recovery of the accompanying error message.
1028 The schema must be empty. It contains at least one
object
object-name .
1029 Object object-name could not be created.
1030 File label Guardian name could not be accessed. File
system error error .