HPE NonStop SQL/MX Error – 3074 The SEPARATE BY clause is not supported.

In this blog post, let’s learn about the error message “3074 The SEPARATE BY clause is not supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3074 The SEPARATE BY clause is not supported.

Reason for the Error

You specified the SEPARATE BY clause, which is not supported.

Solution

Correct the syntax and resubmit