IQ may output a conversion error when using the CAST function in the join condition.
(DBA)> select count() from Tab1 as T1 left outer join Tab2 as T2 on T2.uname = T1.uname left outer join Tab1 as T3 on T3.uname = T1.uname and cast(T2.umonth || '01' as date) = cast(T1.umonth || '01' as date);
There was an error reading the results of the SQL statement.
The displayed results may be incorrect or incomplete.
Data exception - data type conversion is not possible.
SQLCODE=-1001006, ODBC 3 State="HY000"
- SAP IQ 16.1
- SAP IQ 16.0
- SAP IQ 15.4
- SAP Sybase IQ 15.2
- SAP Sybase IQ 12.7
Join, Cast, Date, string, char, varchar, HY000, dfe_Cast.cxx, data type conversion , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.