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 for Me (Login required).

Search for additional results

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