- 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 , Data Services Job Execution , Bug Filed
About this pageThis 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.