SAP Knowledge Base Article - Preview

2109962 - Interpolation of the global variable doesn't work after upgrade - SAP Data Services 14.2.x

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.