Explanation
You are trying to subtract incompatible data types. xx and zz represent the hexadecimal data type values. See the CA Datacom/DB SQL User Guide for DATE/TIME arithmetic rules.
The SQLSTATE that equates to this SQL return code is 42818.
User Response
Correct the query to subtract compatible data types.
|
Copyright © 2014 CA.
All rights reserved.
|
|