In this blog post, let’s learn about the error message “4351 Set Transaction multi commit option is supported only for DELETE statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4351 Set Transaction multi commit option is supported only for DELETE statements.
Reason for the Error
You specified an INSERT or UPDATE statement when multi commit option was ON.
Solution
Use only DELETE statements when multi commit option is ON. To issue other statements, use a SET transaction statement to set the multi commit option to OFF
