2115899 - DBS-070404 SQL submitted to ODBC data source <***> resulted in error <[Sybase][ODBC Driver][Sybase IQ] Feature, input datatype DATEFORMAT at line 1, is not supported - SAP Data Services 14.2 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2115899 - DBS-070404 SQL submitted to ODBC data source <***> resulted in error <[Sybase][ODBC Driver][Sybase IQ] Feature, input datatype DATEFORMAT at line 1, is not supported - SAP Data Services 14.2

Symptom

  • Job fails with "DBS-070404 SQL submitted to ODBC data source <***> resulted in error <[Sybase][ODBC Driver][Sybase IQ] Feature, input datatype DATEFORMAT at line 1, is not supported."
  • When using to_char function to cast a number to a character SAP Data Services tries to push it down using the DATEFORMAT function.
  • DATEFORMAT function is only usable for date to char functions, whereas SAP Data Services function to_char also allows numeric input.

Read more...

Environment

  • SAP Data Services 14.2.4.668
  • SAP IQ 16.0 SP03 and higher
  • Windows 2008 R2

Product

SAP Data Services 4.2 ; SAP IQ 16.0

Keywords

bods, sybase IQ, to_char, dataformat , KBA , EIM-DS-EXE , Data Services Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.