HPE NonStop SQL/MX Error – 9226 The SAMPLE clause is ignored when specified with NECESSARY clause.

Data 16 Views 1 Min Read

In this blog post, let’s learn about the error message “9226 The SAMPLE clause is ignored when specified with NECESSARY clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

9226 The SAMPLE clause is ignored when specified with NECESSARY clause.

Reason for the Error

Sampling option is specified along with NECESSARY COLUMN[S] option of UPDATE STATISTICS command.

Solution

None

Tags: