- Error: "(R) (9552:8944) DBS-070404: |Session <job name> SQL submitted to ODBC data source <TD Source> resulted in error <[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: expected something between the word 'part of sql query' and ','. >. The SQL submitted is <SELECT substring(COLUMN NAME,1,4) as COLUMN NAME, ... FROM TABLE NAME>.
- Connecting to a newer version of Teradata where the use of substring() function is discontinued.
- This is custom sql written by the enduser (customer) and called by the SQL() function in a Data Services script or custom function (SQL is NOT generated by Data Services itself, but built by the enduser and just passed to the database using the SQL() function in scripting).
- SAP Data Services
- Teradata 15 or later
SAP Data Services all versions
KBA , EIM-DS-EXE , Data Services Job Execution , Problem
About this pageThis 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.