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-38
SQL 20145
Cause. You attempted to perform a PURGEDATA operation on a table by specifying a
key range. The table is not a key-sequenced table and therefore there are no key
ranges to specify.
Effect. The operation fails.
Recovery. Perform the PURGEDATA request without specifying key ranges.
SQL 20146
Cause. The key value you specified in the partition map clause does not specify a
valid partition.
Effect. The operation fails.
Recovery. Specify a valid partition map and resubmit.
SQL 20147
Cause. The range that you specified is empty.
Effect. The operation fails.
Recovery. Verify the key range and resubmit.
SQL 20148
Cause. The list of partitions specified in the key range has the same begin and end
key. There are no partitions to purge.
Effect. The operation fails.
Recovery. Specify a valid key range and resubmit.
20145 Key range specified for a table that is not a key-
sequenced table. PURGEDATA cannot be performed.
20146 Key does not exist. Cannot perform PURGEDATA.
20147 User specified an empty range. Cannot perform
PURGEDATA.
20148 Begin key same as end key. PURGEDATA cannot be
performed.