In this blog post, let’s learn about the error message “20732 The time given in the AFTER clause is more than 30 days in the future.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20732 The time given in the AFTER clause is more than 30 days in the future.
Reason for the Error
The MODIFY command includes a COMMIT AFTER timestamp clause, and the timestamp specifies a time that is more than 30 days in the future.
Solution
Correct the COMMIT AFTER clause to use a time within 30 days of the present, and resubmit