In this blog post, let’s learn about the error message “3013 Subtraction is the only operation allowed in the parenthesized expression preceding an interval qualifier.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3013 Subtraction is the only operation allowed in the parenthesized expression preceding an interval qualifier.
Reason for the Error
You specified an expression with invalid syntax. Only subtraction is supported in the parenthesized expression that precedes an interval qualifier.
Solution
Correct the syntax and resubmit