HPE NonStop SQL/MX Error – 3108 The LIKE clause and STORE BY clause cannot coexist in the same statement.

In this blog post, let’s learn about the error message “3108 The LIKE clause and STORE BY 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

3108 The LIKE clause and STORE BY clause cannot coexist in the same statement.

Reason for the Error

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

Solution

Correct the statement to include one of these clauses