SAP Knowledge Base Article - Preview

2120879 - The nvl() function works with unexpected results while processing large dataset - Data Services 4.2


  • The nvl() function returns wrong values.
  • The same job works fine on Data Services 4.0.
  • The issue only happens when processing certain amount of data.  With small dataset, the issue won't happen.
  • For example, nvl(column, -1), when there is a large amount of data, the result may become 0 or null but not -1.



Data Services 4.2


SAP Data Services 4.2


nvl, wrong, null, 0, large, DS , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.