SAP Knowledge Base Article - Preview

2123777 - LOAD TABLE from a binary file fails with conversion error - SAP IQ


  • IQ on LINUX could not load a table, using FORMAT BINARY and BYTE ORDER HIGH, from a BINARY FILE created on Solaris.
  • IQ generated the following error:

Could not execute statement.
Cannot convert 3315 to a datetime(23) (column a_column_name)
SQLCODE=-157, ODBC 3 State="07006"
File: "load_file_name" on line 1, column 1



  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP IQ 15.2
  • Linux


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


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.