SQL/MX 2.x Messages Manual (H06.04+)

Utility Messages (20000 through 23099)
HP NonStop SQL/MX Messages Manual—540498-003
17-32
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
Cause. You attempted to perform a PURGEDATA 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
Cause. The target name you specified was not valid.
Effect. The operation fails.
Recovery. Specify a valid name and resubmit.
20122 Table has indexes. Cannot purge data from partition.
20123 A user-defined transaction has been started. PURGEDATA
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 table exists.
DUP operation failed.