SAP Knowledge Base Article - Preview

1993936 - After upgrade from Data Integrator to Data Services 4.x, recordset returned is different.

Symptom

  • ANSI_Varchar_Behavior has no effect
  • NULL records were returned in the original dataset, now are not.
  • There were many outer joins in the FROM clause.
  • The generated SQL in Data Integrator version shows the join being done in the where clause.
  • The generated SQL in Data Services does the join in the FROM clause and then applies the where clause.


Read more...

Environment

SAP Data Services

Product

SAP Data Services 4.0

Keywords

DI, DSXI, BODS , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.