SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Utility Messages (20000 through 23099)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
19-33
SQL 20122
Cause. You attempted to perform a partial PURGEDATA operation, which is supported
only on tables that do not have dependent indexes. The table you requested has
dependent indexes.
Effect. The operation fails.
Recovery. Remove any associated indexes and resubmit. If this is not possible,
perform a DELETE request in the range of the specified partition.
SQL 20123
Where Utility-operation is the current utility operation.
Cause. You attempted to perform a utility operation after a user-defined transaction
was started.
Effect. The operation fails.
Recovery. Commit or roll back the transaction and resubmit.
SQL 20125
Where table name is the name of the table specified in the PURGEDATA operation.
Cause. The table name that you specified was a metadata table. You cannot
perform the PURGEDATA operation on metadata tables.
Effect. The operation fails.
Recovery. Specify a different table and resubmit.
SQL 20127
Where object-type is a table.
Cause. The target name you specified was not valid.
Effect. The operation fails.
20122 Table has indexes. Cannot purge data from partition.
20123 A user-defined transaction has been started. Utility-
operation cannot be performed.
20125 table name is a metadata table. PURGEDATA cannot be
performed on metadata tables.
20127 Target option was specified as NEW but object-type
exists. DUP operation failed.