SAP Knowledge Base Article - Preview

1968641 - Trailing sapaces not ignored in DS 4.2 engine comparison

Symptom

  • Incorrect Data Services engine comparison of 2 almost identical rows via DISTINCT where only difference is one field of varchar type haivng a  trailing blank in one row and not in the other – i.e. ‘7000’ and ‘7000 ‘.
  • In DS 4.0: Engine Distinct disregards the trailing blank and returns 1 row.
  • In DS 4.2: Engine Distinct does not disregard the trailing blank and returns 2 rows.
  • Different behavior then expected and explained in KBA: 1267193 - What does the ANSI_Varchar_Behavior setting do? - Data Integrator 11.5.x and later/Data Services XI


Read more...

Environment

SAP Data Services 4.2

Product

SAP Data Services 4.2

Keywords

BODS, BODI, DI, Edge, Error after Upgrade, trailin, compared, compares, wrong, fails to, 14.2 , KBA , EIM-DS-EXE , Job Execution , Bug Filed

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.