SAP Knowledge Base Article - Preview

2572000 - IQ returns a conversion error when specifying conversion of character string to date as a join condition - SAP IQ

Symptom

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);
count()
--------------------
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.
  --
  (dflib/dfe_Cast.cxx 840)
  SQLCODE=-1001006, ODBC 3 State="HY000"


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.2
  • SAP Sybase IQ 12.7

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

Join, Cast, Date, string, char, varchar, HY000, dfe_Cast.cxx, data type conversion , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This 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.