Neoview Messages Manual (R2.2)

Effect The operation fails.
Recovery Log on as the services ID before executing this command.
SQL 1075
1075 The catalog must be empty. It contains at least one schema
schema-name.
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
1077 Metadata table table-name does not contain information for view
view-name.
table-name
is the name of the metadata table.
view-name
is the name of a view.
Cause HP Neoview database software required metadata information about object
view-name but was unable to find it in table-name.
Effect The operation fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 1078
1078 The format of the specified location name ‘location-name’ is not
valid.
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 Neoview SQL Reference Manual for limitations on names allowed in the
LOCATION clause. Correct the name and resubmit.
SQL 1079
1079 SQL/MX was not able to prepare the statement.
Cause See the accompanying error message for the cause.
Effect The operation fails.
Recovery Apply the recovery of the accompanying error message.
SQL 1080
1080 The DDL request has duplicate references to column column-name.
column-name
is the name of a column of a table.
Cause You attempted to create a table that has two columns with the same name. If you
name a column “SYSKEY,” duplication can result from the implicit creation by the HP Neoview
database software of a column named SYSKEY to ensure uniqueness for the clustering key.
Effect The operation fails.
Recovery Remove duplicate column names and resubmit.
30 Data Definition Language (DDL) Messages (1000 Through 1999)