HPE NonStop SQL/MX Error – 3116 Duplicate transaction access mode clauses were specified.

In this blog post, let’s learn about the error message “3116 Duplicate transaction access mode clauses were specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3116 Duplicate transaction access mode clauses were specified.

Reason for the Error

You specified a statement with duplicate access mode clauses.

Solution

Correct the syntax and resubmit