SAP Knowledge Base Article - Preview

2972892 - Substr() function not pushing down to database - Data Services


  • A job that has a substr() function loading to a datetime column will fail with the following error.
    Error " <SQLFetchScroll>: <[IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 >." 
  • The optimized SQL will show an "Insert into" statement instead of "Select" statestament, meaning it is not being pushed down.
  • Worked successfully in earlier versions of Data Services
  • Found SAPnote 2521441 - Function substr() is not pushed down in DB2, but it is no longer valid



  • SAP Data Services 14.2.x
  • DB2


SAP Data Services 4.2


substr(), date time conversion, datetime , KBA , EIM-DS-DES , User Interface/Designer , EIM-DS , Data Services , EIM-DS-EXE , Job Execution , 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.