Neoview Messages Manual (Volume 1) (R2.5)

Effect The statement fails unless it includes the optional REUSE clause to allow reuse of the

same schema subvolume name. If the REUSE clause is used, this is a warning message and

the schema is created successfully. The warning can be issued repeatedly for a single CREATE

SCHEMA command if multiple schemas already exist with subvolume as the schema

subvolume.

Recovery Only schemas that are RDF replicated to another segment should have the same

subvolume names as their corresponding schemas on the other segment. To create these, use

the optional REUSE clause in the CREATE SCHEMA statement. All other schemas should

have unique subvolume names. Schemas that are, or will be, related as RDF primary and

backup schemas must have identical schema names and subvolumes on the primary and

backup segments.

SQL 1306

1306 SQL/MX was not able to generate a unique schema location for schema

schema.

schema

is the ANSI name of the schema specified in the CREATE SCHEMA command.

Cause In a CREATE SCHEMA command, you did not specify a LOCATION clause, so the

HP Neoview database software was unable to generate a schema subvolume name that is not

already being used by existing schemas.

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 1307

1307 The schema location subvolume is reserved for SQL/MX metadata.

subvolume

is the HP Neoview platform subvolume name specified in the LOCATION

clause of the CREATE SCHEMA command.

Cause In a CREATE SCHEMA command, you specified subvolume in the LOCATION

clause, however subvolume names with the format ZSDdigitanything are reserved for HP

Neoview database software metadata schemas.

Effect The operation fails.

Recovery Specify a subvolume name using the format ZSDdigitanything in the

LOCATION clause, and resubmit.

SQL 1309

1309 Object type for object-name is not valid for the current operation.

object-name

is the name of the object.

Cause You specified an object for an SQL operation that does not support its object type.

Effect The operation fails.

Recovery Specify an object of valid object type and retry the operation.

SQL 1310

1310 The CREATE SCHEMA statement does not support the creation of

triggers.

Cause You specified creation of triggers in the CREATE SCHEMA statement.

Effect The operation fails.

Recovery Remove the creation of triggers from the CREATE SCHEMA statement and

resubmit. Create triggers in separate statements.