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
