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 , 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 for Me (Login required).

Search for additional results

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