In this blog post, let’s learn about the error message “9221 The specified table table-name is not a SQL/MX table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9221 The specified table table-name is not a SQL/MX table.
Reason for the Error
Either the table for which the statistics have to be collected, or the user-specified sample table, is not a SQL/MX table – it is either a SQL/MP table or some other object such as, index or a view. The USING SAMPLE TABLE clause is supported for SQL/MX tables only.
Solution
Specify a SQL/MX table name. For running the UPDATE STATISTICS command on a SQL/MP table, do not use the USING SAMPLE TABLE clause
