HP Neoview Messages, Manual

Page: 19 / 400

SQL 1025
1025 Request failed. One or more dependent objects exist.
Cause This error can occur when you drop a constraint, index, or table. These objects cannot
be dropped if they have dependent objects and the drop-behavior is RESTRICT.
Effect
The HP Neoview database software does not perform the operation.
Recovery
For DROP statements that support the CASCADE drop-behavior, you can reissue
the statement specifying CASCADE. For other DROP statements, you must first drop each of
the dependent objects, then drop the object.
SQL 1026
1026 Only the schema owner or super ID can drop a schema.
Cause An attempt was made to drop a schema by someone other than its owner or the super
ID.
Effect
No SQL objects are dropped.
Recovery The owner of the schema (or super ID) needs to issue the DROP SCHEMA statement.
SQL 1027
1027 The definition schema definition-schema-name is dropped when its
catalog is dropped.
definition-schema-name
is the name of the definition schema specified.
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
1028 The schema must be empty. It contains at least one object
object-name.
object-name
is the name of an HP Neoview database 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
1029 Object object-name could not be created.
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
1030 File label file name could not be accessed. File system error
error.
file name
is the name of an HP Neoview database file.
19