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-65
SQL 1307
Where subvolume is the Guardian 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 ZSDdigit>anything> are
reserved for SQL/MX metadata schemas.
Effect. The operation fails.
Recovery. Specify a subvolume name using the format ZSDletter>anything> in
the LOCATION clause, and resubmit.
SQL 1309
Where 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
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.
SQL 1311
Where action-text is create.
1307 The schema location subvolume is reserved for SQL/MX
metadata.
1309 Object type for object-name is not valid for the current
operation.
1310 The CREATE SCHEMA statement does not support the
creation of triggers.
1311 Unable to action-text constraint constraint-name due to
the above errors.