SAP Knowledge Base Article - Preview

2647599 - How to convert blank values into NULL for Oracle - SAP Data Services

Symptom

  • Blank spaces are not converted into NULL when loading to Oracle
  • How do you allow SQL blank fields to be loaded as NULLS in Oracle?
  • Oracle table is loaded with spaces not NULLS
  • SQL Server empty string is not loaded as a NULL in Oracle


Read more...

Environment

  • SAP Data Services 4.2
  • Oracle

Product

SAP Data Services 4.2

Keywords

blank, space, bulkload, bulk load, sql, bods, target, empty, ds, len, len(), length , KBA , EIM-DS-EXE , Job Execution , How To

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.