HPE NonStop SQL/MX Error – 20191 This operation is not supported on nonaudited tables.

In this blog post, let’s learn about the error message “20191 This operation is not supported on nonaudited tables.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20191 This operation is not supported on nonaudited tables.

Reason for the Error

You issued a MODIFY request on a nonaudited table, which is not supported.

Solution

If the MODIFY operation is required, alter the table to audited, perform the MODIFY, and then alter the table back to nonaudited