Hi, need help with db2. Have a query like:
SELECT H.DocumentNumbe r, H.AssignedUser
FROM AP.DocumentHead er H, AP.DocumentLine L
WHERE H.UpdDate > current_date - 2
but getting error SQL0401N The data types of the operands for the operation ">" are not compatible.
Explanation: The operation "<operator> " appearing within the SQL statement has a mixture of numeric and nonnumeric operands,...