SAP Knowledge Base Article - Preview

3254757 - Error "Cannot convert 'xxxx' to [datatype]' when create partition - SAP IQ


The following error reported when create a range partition table where the column datatype is defined as varchar and value in the RANG clause is an integer.

[SAP][ODBC Driver][SAP IQ]Cannot convert '20241231' to varchar  



  • SAP IQ 16.x
  • SAP Hana Cloud Hana Data Lake


SAP HANA Cloud all versions


IQ, SAP IQ, HANA, Data Lake, convert, conversion, partition, range , KBA , BC-SYB-IQ , Sybase IQ , HAN-CLS-HC-HDL , HANA Cloud HANA Data Lake , How To

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.