2373329 - SUBSTR function failing on Teradata 15.10, SA Data Services | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2373329 - SUBSTR function failing on Teradata 15.10, SA Data Services

Symptom

  • Error: expected something between the word '<>' and ','. > while running a query that implicitly used the substring functioin in the ewxecution plan, SAP Data Services 14.2.5
  • BODS itself calls the function in the SQL that gets generated.
  • Full error:
  • SQL submitted to ODBC data source <TD_Dev_UTF8> resulted in error <[Teradata][ODBC Teradata Driver][Teradata Database] Syntax
    12064 4744 DBS-070404 9/27/2016 10:54:44 error: expected something between the word '<>'and ','. >. The SQL submitted is <INSERT INTO
    12064 4744 DBS-070404 9/27/2016 10:54:44 "<table>" ( "", "" , substring( "<>"."<>" , 1, 5)  AS "<>" ,
    12064 4744 DBS-070404 9/27/2016 10:54:44 "......

Read more...

Environment

  • SAP Data Services 14.2.5 Patch 3
  • Teradata 15.10
  • All supported platforms

Product

SAP Data Integrator XI R2

Keywords

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.