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.