In this blog post, let’s learn about the error message “4034 The operation (data type operation data type)operation is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4034 The operation (data type operation data type)operation is not allowed.
Reason for the Error
You attempted to perform an arithmetic operation on a DATETIME field using other DATETIME or INTERVAL expressions that do not have identical start and end fields.
Solution
Correct the syntax and resubmit