In this blog post, let’s learn about the error message “9218 Unable to delete all records from the table table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9218 Unable to delete all records from the table table-name.
Reason for the Error
The data in the sample table could not be deleted. When the SAMPLE clause is specified, the UPDATE STATISTICS command populates the sample table with some temporary records. At the end of the operation, these records are deleted.
Solution
Execute either a DELETE statement or a PURGEDATA command on the table
