- 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 pageThis 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.