In this blog post, let’s learn about the error message “20733 The times given in ONCOMMITERROR clauses are not in ascending order.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20733 The times given in ONCOMMITERROR clauses are not in ascending order.
Reason for the Error
The MODIFY command includes multiple COMMIT BEFORE and/or COMMIT AFTER clauses, and a time given in one such clause is earlier than one given in some preceding clause.
Solution
Correct the COMMIT clauses so that they are in ascending order in time, and retry the operation
