SAP Knowledge Base Article - Preview

1675137 - CSV load of type long and value <NULL> results in space when loading to oracle table via api bulk load

Symptom

  • Empty strings of type "Long" are treated as null between data services and Oracle "Clob" for a job run with Bulk mode deactivated.
  • Empty strings of type "Long" contain spaces in queries between data services and Oracle "Clob" for a job run in Bulk mode.
  • These fields are thus processed as though they contained Data whereas they should be treated as null


Read more...

Environment

  • Data Services Version 12.2.3.0
  • Repo 12.2.2.0
  • DS Operating System Wndows 2008 64Bit
  • Database Oracle 11.2.0.1.0

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

KBA , EIM-DI , Data Integrator, Composer , 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.