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

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

3111 The LIKE clause and LOCATION clause cannot coexist in the same statement.

Reason for the Error

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

Solution

Correct the statement to include one of these clauses