SAP Knowledge Base Article - Preview

3555693 - In the SQL statement of a script, how to use alias name with table correctly? - SAP Data Services

Symptom

  • In the SQL statement of a script, how to use alias name with table correctly?
  • Script using the sql('datastoreName','select * from aliasName.tableName'). The job containing such script will fail
  • Error: "Error message for operation <SQLExecute>. Invalid object name 'aliasName.tableName'. Statement(s) could not be prepared"


Read more...

Environment

SAP Data Services

Product

SAP Data Services 4.2 ; SAP Data Services 4.3

Keywords

alias, datastore, DB configurations, table, DS job, script, SQL, owner , 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.