In this blog post, let’s learn about the error message “9224 The NECESSARY clause is only allowed on tables of schema version 3000 or higher.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9224 The NECESSARY clause is only allowed on tables of schema version 3000 or higher.
Reason for the Error
The UPDATE STATISTICS or SHOWSTATS command with NECESSARY COLUMN[S] option is used on a table with schema version lower than 3000.
Solution
Use NECESSARY COLUMN[S] option on a table with schema version 3000 or higher
