HPE NonStop SQL/MX Error – 3112 The LIKE clause and PARTITION clause cannot coexist in the same statement.

In this blog post, let’s learn about the error message “3112 The LIKE clause and PARTITION clause cannot coexist in the same statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3112 The LIKE clause and PARTITION clause cannot coexist in the same statement.

Reason for the Error

You specified a statement with both LIKE and PARTITION clauses, which is not supported.

Solution

Correct the statement to include one of these clauses