Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How do i set to Space/Blank on HANA table-datatype as CHAR with Data-Services.


I am trying to load the HANA table. The source is a extract (Fixed Flat file) of a Mainframe DB2 table. After i extract i am running the following DS dataflow.

Flatfile-->Tablecompare(Filefile data Vs Hana table) and then create  3 files.(Insert,Update,Delete) and uses these files to load the hana table.

All the columns which has blanks on flat file are being loaded as Nulls to HANA table. How can i stop this and load the blanks to the table?

Any suggestion will be of great help.


Former Member
Not what you were looking for? View more on this topic or Ask a question