Symptom
- 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
Read more...
Environment
- SAP Data Services 14.2.x
- DB2
Product
SAP Data Services 4.2
Keywords
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.