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-29
SQL 1115
Where Guardian name is the name of the Guardian file for the label creation that
failed.
Where ANSI name is the name of the table.
Where error is the error number returned.
Cause. A file system error occurred on the attempt to create the label.
Effect. The table is not created.
Recovery. Correct the file system error and reissue the CREATE statement.
SQL 1116
Where table-name is the name of the table.
Cause. The partitioning scheme requires a user-specified clustering key.
Effect. The operation fails.
Recovery. Specify a clustering key, either through a PRIMARY KEY, STORE BY, or
PARTITION BY clause.
SQL 1117
Cause. You attempted to drop the only partition of the object.
Effect. The operation fails.
Recovery. None.
SQL 1118
Where table-name is the name of the object.
Cause. You attempted to create an object in the metadata schema.
1115 Label Guardian name could not be created for ANSI name
(file error error).
1116 The current partitioning scheme requires a user-
specified clustering key on object table-name.
1117 Dropping the only partition of an object is not allowed.
At least two partitions must exist to perform the drop.
1118 Creating object table-name is not allowed in metadata
schema.