In this blog post, let’s learn about the error message “9204 Invalid option option specified. Value must be range.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9204 Invalid option option specified. Value must be range.
Reason for the Error
You specified an invalid option for UPDATE STATISTICS. The value range specifies the valid range for this option.
Solution
Correct the syntax and resubmit
