HPE NonStop SQL/MX Error – 3094 The DEALLOCATE clause is not allowed in the CREATE INDEX statements.

In this blog post, let’s learn about the error message “3094 The DEALLOCATE clause is not allowed in the CREATE INDEX statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3094 The DEALLOCATE clause is not allowed in the CREATE INDEX statements.

Reason for the Error

You specified a CREATE INDEX statement that includes the DEALLOCATE clause, which is not supported.

Solution

Correct the syntax and resubmit