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.