SQL Codes › SQL Return Codes -1 through -999 › -194 - IT IS INVALID TO ADD xx AND zz DATATYPES

-194 - IT IS INVALID TO ADD xx AND zz DATATYPES

Explanation

You are trying to add 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 add compatible data types