Symptom
- Interpolation of the global variable doesn't work after upgrade.
- Global variable (varchar) assigned a table name: $GV_VIEW_NAME = 'owner.TABLE';
- Global variable is being called from SQL Transform using square brackets : select count(*) as num_of_lines from [$GV_VIEW_NAME]
DBS-070404: |Data flow <DF_NAME>|Reader SQL: SQL submitted to ODBC data source <TD> resulted in error <[Teradata][ODBC Teradata Driver][Teradata Database] Object 'o' does not exist. - Global variable is being called from SQL Transform using curly brackets : select count(*) as num_of_lines from {$GV_VIEW_NAME}
DBS-070404: |Data flow <DF_NAME>|Embedded Dataflow check_view_rows|Reader SQL
SQL submitted to ODBC data source <TD> resulted in error <[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like a name or a Unicode delimited identifier or '(' between the 'from' keyword and the string 'd' keyword. >. The SQL submitted is <Select count(*) as num_of_lines from 'owner.TABLE'; - Hardcoded name of the table works just fine.
Read more...
Environment
- SAP Data Services 14.2.3.618
- Teradata 13.10
- Windows 2008R2
Product
SAP Data Services 4.2
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.
SAP Knowledge Base Article - Preview