SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Utility Messages (20000 through 23099)
HP NonStop SQL/MX Messages Manual—523730-004
17-56
Recovery. Use the messages that accompany this one to diagnose and correct the
problem.
SQL 20230
Cause. You tried to drop the only remaining partition of a table or index.
Effect. The operation fails.
Recovery. If you want to drop the last remaining partition, use the DROP TABLE or
INDEX statement.
SQL 20231
Cause. You issued a request containing syntax that is valid only with a hash-partition
table or index.
Effect. The operation fails.
Recovery. Check the syntax and resubmit.
SQL 20232
Cause. You tried to perform a MODIFY utility on a nonaudited table containing data.
Effect. The operation fails.
Recovery. None.
SQL 20233
Where volume-name is the name of the volume.
Cause. The MODIFY utility could not find, in volume volume-name, partitions that
belong to the specified object.
Effect. The operation fails.
20230 You cannot drop all partitions of the table or index.
At least one partition must remain.
20231 The specified syntax is valid only with a hash-
partitioned table or index.
20232 This operation cannot be done on a nonaudited table
that contains data.
20233 No partition could be found in volume volume name for
the specified object.