HPE NonStop SQL/MX Error – 3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in the same ALTER INDEX statement.

Data 21 Views 1 Min Read

In this blog post, let’s learn about the error message “3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in the same ALTER INDEX statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in the same ALTER INDEX statement.

Reason for the Error

You specified an ALTER INDEX statement with both an ALLOCATE and a DEALLOCATE clause, which is not supported.

Solution

Correct the ALTER INDEX statement to include either ALLOCATE or DEALLOCATE

Tags: